Friday, July 11, 2008

Script:How to check startup time for a database.

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;

1 comment:

Anonymous said...

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!!