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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,564 views