Thursday, September 11, 2014

How to See When Your Database Was Opened

This was tested on Oracle 11.2: 

SQL> l
  1* select startup_time from v$instance
SQL> /
 
STARTUP_TIME
------------
24-MAY-12
 
SQL>


2 comments:

Anonymous said...

I guess the right answer will be:

select open_time from v$thread;

Because instance startup is not necessarily mean database been opened.

Andrew Reid said...

Dear Anonymous,

Thank you for your comment.
I never thought of that.
I will try to build your idea into the example next week.

Kind Regards,

Andrew