Donald K. Burleson Oracle Tips

How long has my database been up?

The following script can be used to determine the uptime for any Oracle database.  The data is stored in the v$_session system view in the logon_time column.  By displaying the login_time for the Oracle process minitor background process (PMON), we can determine the time that the Oracle database was started.

select

   to_char(logon_time,'Dy dd Mon HH24:MI:SS')

      "Oracle Startup Time"

from

      sys.v_$session

where

   sid=1   -- sid=1 represents the PMON process

;

Here is the output:

Oracle Startup Time

-------------------

Tue 20 Mar 07:03:24