Wednesday, May 25, 2011

How to see the uptime for an Oracle Database?



Run the below query in the SQL prompt..



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


You can see the startup time from the Oracle EM home page also..



No comments:

Post a Comment