Thursday, September 11, 2014

How to See When Your Database Was Opened

This was tested on Oracle 11.2:

Posted by at
Labels: , , ,
Location: West Sussex, UK

2 comments:

  1. Anonymous1:48 pm

    I guess the right answer will be:

    select open_time from v$thread;

    Because instance startup is not necessarily mean database been opened.

    ReplyDelete
  2. Andrew Reid11:29 pm

    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

    ReplyDelete

Subscribe to: Post Comments (Atom)