Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using the OEM repository to query all database-sizes (including history)

Mark LOct 5 2017 — edited Oct 23 2017

Hi,

We have Enterprise Manager 13C with build-in BiPublisher.

I have made some useful reports (for example all IO's per database, etc.), but till now, I am only able to get it for the IOPS on a hourly base.

For example, this is my average IOPS graph (per database, IOPS per hour).

AVR IOPS per hour.png

I want to query the repository-database to retrieve the size of all databases in our Enterprise Manager (including historical sizes on a daily base).
Raising an SR with Oracle does not lead to an answer, they asked me to put this as a question in the community.

My questions:
Q1- Does any one know how my query must look like? (anyone with this experience yet?) Or is there a default report which I can use for it? (it seems that the default reports do not fit my requirements. But maybe I miss something )

and
Q2 - Does any one knows if there is a community-page (or something like that) where we can share custom OEM BI-Publisher query's/reports?

Regards,
Mark

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 20 2017

Added on Oct 5 2017

2 comments

1,735 views