Oracle server uptime


The following query works well with Oracle 9i. i’ve no clue whether this works with others too or not.

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

even there is possiblity to find the startup time by quering logon_time from sys.v_$session view.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.