OraFAQ Forum: Enterprise Manager » How Oracle enterprise Manager finds the "Availability for Last 7 Days" for a Database instance

Home » RDBMS Server » Enterprise Manager » How Oracle enterprise Manager finds the "Availability for Last 7 Days" for a Database instance (Oracle Enterprise Manager 13C)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How Oracle enterprise Manager finds the "Availability for Last 7 Days" for a Database instance [message #670955]

Tue, 07 August 2018 04:36

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,

Report message to a moderator

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

JPBoileau
Messages: 88
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;

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 30 10:04:22 CDT 2023