Re: OEM reports

From: Rich Jesse <>
Date: Fri, 29 Feb 2008 12:50:20 -0600 (CST)
Message-ID: <52033.>

Hey Tom,

Check out the views in the SYSMAN schema. This ought to get you started:

select *
from sysman.mgmt$db_init_params
where name = 'db_recovery_file_dest_size';

BTW, this was run against the repository database for Grid Control v10.

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
> before?
> 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.
> Tom
> --

Received on Fri Feb 29 2008 - 12:50:20 CST

Original text of this message