How To See When The Database Startup

The other day talking with a co-worker the comment how to see the time when the database startup. I have to say in their defense that he has a lot of years of experience, although I also am. The issue is that he uses this statement;

DARMA*ANTO> SELECT MIN (LOGON_TIME) FROM V$SESSION WHERE
  2  SERVICE_name ='SYS$BACKGROUND';

MIN(LOGON_TIME)
____________________
13/ABR/2015 07:43:32

Formerly in versions 6 and 7 of Oracle such tricks they were very common. Currently to view an official way we can execute a select on the view v$instance. As shown in the following example.

DARMA*ANTO> select startup_time from v$instance;

STARTUP_TIME
____________________
13/ABR/2015 07:43:31

Another option, though perhaps more uncomfortable, is to look at alert.log

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s