Query - When ORACLE server/databas has been started

sholtan · #1 (**permalink**) 09-05-10, 16:31

I'm trying to find out when ORACLE DATABASE/SERVER started and how long it has been running. Is there query or command in that I can use to check this? Is there more than one option to find this out and is it same for all ORACLE versions or diffferent from version to version?

Thanks

magicwand · #2 (**permalink**) 09-05-10, 16:37

Would be much easier to answer, if you told us which OS you are using ...

anacedent · #3 (**permalink**) 09-05-10, 17:05

Oracle database FAQ - Oracle FAQ

Code:

  1  SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time",
  2  to_char(round((sysdate-startup_time)*24*60)) UP_TIME_MINUTES
  3* FROM   sys.v_$instance
SQL> /

DB Startup Time 	      UP_TIME_MINUTES
----------------------------- ----------------------------------------
05-SEP-2010 06:57:30	      837

Internet Services

Web Development

Digital Marketing

Consumer Tech