Wednesday, August 31, 2016

Database STARTUP_TIME History


set lines 1000
col STARTUP_TIME for a25
col platform for a40

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 order by STARTUP_TIME;

1 comment:

Anonymous said...

Good commentary , For what it's worth , if someone requires a DD 2 & DD 1173 , I edited a sample form here form 2 1173.