Health check report using OEM 12c
Hi All,
I am trying to schedule a database health check report from OEM 12c and I am using a shell script which calls following sql script
Prompt
Prompt DATABASE STATUS:
Prompt =================
select a.instance_name,a.status,to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') UPTIME,a.logins,b.open_mode from v$instance a,v$database b;
Prompt
Prompt SCHEMA WISE ANALYZE INFORMATION:
Prompt ================================
select distinct owner,to_char(last_analyzed,'DD-MON-YYYY') "Last Analyzed"
from dba_tables
where owner not like '%SYS%' and owner not in ('PERFSTAT','DBSNMP','OUTLN','XDB','SPOTLIGHT');
col object_name format a40
I am trying to schedule a database health check report from OEM 12c and I am using a shell script which calls following sql script
Prompt
Prompt DATABASE STATUS:
Prompt =================
select a.instance_name,a.status,to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') UPTIME,a.logins,b.open_mode from v$instance a,v$database b;
Prompt
Prompt SCHEMA WISE ANALYZE INFORMATION:
Prompt ================================
select distinct owner,to_char(last_analyzed,'DD-MON-YYYY') "Last Analyzed"
from dba_tables
where owner not like '%SYS%' and owner not in ('PERFSTAT','DBSNMP','OUTLN','XDB','SPOTLIGHT');
col object_name format a40
0