Startup time of an Instance

[jcote]

I am pretty shure that there is a dba or v$ view that has the time an inistance was started. I searched for it without success. Does anyone knows this one?

Thanks

 

[rcurva]

Yup, you can use v$thread OPEN_TIME column to know what date & time was the database last opened.

You can also check your alert log for the open time.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[jgaines1]

You can also get the instance startup time from v$instance
select startup_time from v$instance;