Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

How to generate a customized report for the mount point usage on OMS?

edited Jan 6, 2011 9:26AM in Managing Databases using Enterprise Manager (MOSC) 2 commentsAnswered
I'm trying to come up with a report to list all the mount points and usage (percentage of usage), so that I can alert sysadmin to add more space if mountpoints are over 85% full or so.

In OEM grid control, when I click on hosts->select one host->click on local mount points, then it gives me exactly what I want, do you guys know which tables/views, that "click" pulls data from???

I'm looking at the OEM repository tables under sysman, I found a couple of  views.

select * from sysman.MGMT$STORAGE_REPORT_NFS * from sysman.MGMT$STORAGE_REPORT_NFS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center