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
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