Enterprise Manager
Database Growth – OEM
There are many ways to calculate database growth and I’ve certainly had a few, but this is probably the most accurate so far..
Backup Report from Enterprise Manager
How do we report on databases that haven’t been backed up? We create a report from Enterprise manager and see what has failed and what backups are potentially missing Run this in Enterprise Manager /* mark young 23-August 2011 */ SELECT a.HOST_NAME, a.DISPLAY_NAME, CASE WHEN b.end_time < SYSDATE – 2 THEN ‘3. BACKUP OLDER THAN … Read more
Database Capacity Planning
Capacity and Growth Forecast How to estimate the growth and forecast of a database on a host. Step-by-step guide The procedure is at the bottom of this article. Login to enterprise manager from sqlplus (from omsdbaup03) oracle@omsdbaup03:/users/oracle [emrep12c] $ sqlplus sysman/xxxxxx 2. Follow the following to calculate growth for each database on a host SQL> … Read more
Get the Properties From All Targets – Enterprise Manager
SELECT target_name, target_type, user_comment, Contact, department, line_of_business, lifecycle_status FROM SYSMAN.GC$GLOBAL_TARGET_PROPERTIES WHERE target_type IN (‘host’, ‘oracle_instance’, ‘oracle_listener’, ‘cluster_database’) AND line_of_business IS NULL ORDER BY target_name;
CPU usage from Host via Enterprise Manager
SELECT Target_name, Metric_name, Column_label, collection_timestamp, alert_state, alert_duration, MESSAGE FROM MGMT$alert_history WHERE target_guid = ‘CFCF659B637812777B6F46E05A19E47F’ and metric_column=’cpuUtil’ order by collection_timestamp;
Current Incidents for the Week
SELECT t.target_name, t.target_type, el.severity, DECODE (el.open_status, 1, ‘Open’, ‘Closed’), el.msg, el.creation_date, el.incident_num, i.ticket_id FROM mgmt$events_latest el, mgmt$target t, mgmt$incidents i WHERE el.target_guid = t.target_guid AND I.INCIDENT_ID = el.incident_id AND t.target_type IN (‘oracle_listener’, ‘oracle_database’, ‘rac_database’, ‘host’) — AND el.open_status = 1 AND TRUNC (el.creation_date) >= SYSDATE – 7 AND i.ticket_id IS NOT NULL ORDER BY 4 … Read more
How can I view the number of targets blacked out in the last 30 days?
The MGMT$BLACKOUT_HISTORY file contains an overview of all finished blackouts for each target. To view the number of targets blacked out in the last 30 days, enter the following query: SELECT target_type, COUNT (*) cnt FROM mgmt$blackout_history WHERE start_time > SYSDATE – 30 GROUP BY target_type ;
How can I view a list of future scheduled blackouts?
The MGMT$BLACKOUTS file contains definitions of all blackouts known in the system. To view a list of future scheduled blackouts, enter the following query: SELECT blackout_name, reason, created_by, schedule_type, scheduled_time FROM mgmt$blackouts WHERE status = ‘Scheduled’;