The startup time for the database can be viewed with V$INSTANCE view.
And the sql will be like this:
select to_char(startup_time, 'HH24:MI DD-MON-YY') "Startup time"
from v$instance;
Friday, July 11, 2008
Subscribe to:
Post Comments (Atom)
Basic Oracle database Commands and Usages
1 comment:
Just to make it clear, this is to find out the startup time of a database instance only and NOT the database startup time. For ex, if a large transaction database crashes and when restarted, instance may come up immediately but it may take even an hour for database to open fully as it may have to do crash recovery of several blocks. Just my 2 cents!!
Post a Comment