ON CALL DBA SUPPORT

— Database blog

QUERY TO CHECK THE INSTANCE STARTUP TIME IN RAC

Posted by ssgottik on 17/09/2013

set lines 1000

col STARTUP_TIME for a25

col platform for a30

select DBID, INSTANCE_NUMBER INST_NU,STARTUP_TIME,PARALLEL RAC, VERSION, DB_NAME, INSTANCE_NAME,HOST_NAME ,LAST_ASH_SAMPLE_ID ASH_ID,PLATFORM_NAME PLATFORM from dba_hist_database_instance where instance_number=&N order by STARTUP_TIME;

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

 
%d bloggers like this: