Oracle server uptime
Posted On July 23, 2006
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"
even there is possiblity to find the startup time by quering logon_time from sys.v_$session view.