Enterprise Manager

SELECT DISTINCT st.target_name, st.mountpoint, ROUND ( (freeb / 1073741824), 2) AS “Free (GB)”, ROUND ( (sizeb / 1073741824), 2) AS “Size (GB)”, ROUND ( ( ( (sizeb – freeb) / sizeb) * 100), 2) AS “Used (%)” FROM MGMT$STORAGE_REPORT_LOCALFS st, mgmt$os_summary os WHERE st.target_name = os.HOST AND st.mountpoint = ‘/usr/local/oracle’ OR st.mountpoint LIKE ‘/databases%’ OR … Read more

alter session set nls_date_format=’dd/mm/rrrr hh:mi:ss’ SELECT a.incident_id, b.creation_date, b.last_updated_date, b.ticket_id, b.summary_msg, c.target_name, DECODE (a.open_status, ‘1’, ‘Open’, ‘Closed’) FROM mgmt$INCIDENT_TARGET a, mgmt$incidents b, mgmt$target c WHERE a.incident_id = b.incident_id AND a.target_guid = b.target_guid AND a.target_guid = c.target_guid AND LOWER (b.SUMMARY_MSG) LIKE ‘%filesystem%’ AND c.target_type = ‘host’ AND a.open_status = 1 ORDER BY b.last_updated_date DESC