Monday, 8 June 2015

Oracle DB Start Up Time

To find the startup time of an Oracle database:

SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time" FROM sys.v_$instance;


Result:

DB Startup Time
--------------------
09-MAY-2015 20:23:13