Tuesday, January 29, 2013

10g Startup Date/Time


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

Sample Output:
DB Startup Time
--------------------
24-SEP-2012 11:08:40​

No comments:

Post a Comment