Re: OEM reports
Date: Fri, 29 Feb 2008 12:50:20 -0600 (CST)
Check out the views in the SYSMAN schema. This ought to get you started:
where name = 'db_recovery_file_dest_size';
BTW, this was run against the repository database for Grid Control v10.2.0.3.0.
HTH! GL! Rich
> Has anyone written a report/script using the sysman tables in the OEM
> repository? For example, I would like to write a simple report which
> will show me the value of db_recovery_file_dest_size for all of our
> databases. I assume I can piece together the different sysman.mgmt*
> tables to get it done. As anyone already tried something like this
> I tried to create the report with the OEM console (Reports tab) but I
> didn't like the output so I thought I could write it better just going
> against a the actual OEM tables.