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;

Tuesday, August 30, 2016

Golden Gate Lag Monitoring Script


http://sridharramireddy.blogspot.com/2014/09/script-to-monitor-goldengate-monitoring.html