Home » RDBMS Server » Enterprise Manager » How Oracle enterprise Manager finds the "Availability for Last 7 Days" for a Database instance (Oracle Enterprise Manager 13C)
How Oracle enterprise Manager finds the "Availability for Last 7 Days" for a Database instance [message #670955] Tue, 07 August 2018 04:36 Go to next message
manindk
Messages: 1
Registered: August 2018
Junior Member
Hi Mates,



I want to know from which table in the OEM repository database , OEM GUI fetches the information about "Availability for Last 7 Days" for a Database instance.

I need to set a report for all the Databases availability status for last days.



Thanks in advance,
Re: How Oracle enterprise Manager finds the "Availability for Last 7 Days" for a Database instance [message #670961 is a reply to message #670955] Tue, 07 August 2018 07:58 Go to previous message
JPBoileau
Messages: 54
Registered: September 2017
Member
Have a look at the following tables:


select T.TARGET_NAME, A.* from sysman.MGMT_AVAILABILITY A, SYSMAN.MGMT$TARGET T
WHERE T.TARGET_GUID = A.TARGET_GUID AND
UPPER(T.TARGET_NAME) LIKE '%' 
ORDER BY START_COLLECTION_TIMESTAMP DESC;

JP
Previous Topic: FACING CLIENT_OLE2.CREATE_OBJ('Excel.Application');
Next Topic: Cannot create OEM repository
Goto Forum:
  


Current Time: Wed Mar 20 18:17:45 CDT 2019