SQL> select STARTUP_TIME,STATUS,LOGINS,DATABASE_STATUS from v$instance where INSTANCE_NUMBER=1;
STARTUP_T STATUS LOGINS DATABASE_STATUS
--------- ------------ ---------- -----------------
23-JUN-14 OPEN ALLOWED ACTIVE
SQL>
This would show when the DB was started, status and the mode of the DB Started.
No comments:
Post a Comment