long has my database been up?
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.
to_char(logon_time,'Dy dd Mon HH24:MI:SS')
"Oracle Startup Time"
sid=1 -- sid=1
represents the PMON process
Here is the
20 Mar 07:03:24