Look
at the following SQL query
SQL>SELECT to_char (startup_time, 'DD – MON – YYYY HH24: MI: SS') "DB Startup
Time"
FROM sys.v_$instance;
or
SQL>SELECT to_char (logon_time, 'Dy dd Mon HH24: MI: SS') "DB Startup Time"
FROM sys.v_$session
WHERE Sid=1; /* this is pmon */
FROM sys.v_$instance;
or
SQL>SELECT to_char (logon_time, 'Dy dd Mon HH24: MI: SS') "DB Startup Time"
FROM sys.v_$session
WHERE Sid=1; /* this is pmon */