- How to check startup_time of instances in RAC
SQL> select inst_id,instance_name,startup_time from gv$instance;
INST_ID INSTANCE_NAME STARTUP_TIME
-------------------------------------------------------------------------------------
1 otslive1 09-SEP-15
2 otslive2 09-SEP-15
- How to check database creation date.
SQL> select name,created from v$database;
NAME CREATED
-----------------------------------------
OTSLIVE 22-NOV-14
Happy Learning .....
No comments:
Post a Comment