Friday 3 February 2017

How to find the database startup date and time?


SQL> select host_name,instance_name,to_char(startup_time,'DD-MON-YYYY HH24:MI:SS AM') startdate from v$instance;

HOST_NAME                 INSTANCE_NAME                       STARTDATE
---------------                      ---------------                            --------------------------------
subbuapps.erp.com             03-FEB-2017                                14:32:29 PM


No comments:

Post a Comment