Re: OEM reports
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 29 Feb 2008 12:50:20 -0600 (CST)
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.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
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
