Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006

    Unanswered: Query - When ORACLE server/databas has been started

    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?


  2. #2
    Join Date
    Mar 2010
    Vienna, Austria
    Would be much easier to answer, if you told us which OS you are using ...
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    Oracle database FAQ - Oracle FAQ

      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
    Last edited by anacedent; 09-05-10 at 23:55.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts