| custom query on EMREP SCHEMA [message #445597] |
Tue, 02 March 2010 21:34 |
greenscreen
Messages: 1
Registered: March 2010
|
Junior Member |
|
|
I find that EM Grid control is too heavy a tool to monitor and maintain a historical log of various variables per dbinstance per server for us.
I want to query the EMREP Schema via a perl DBI script and extract the data I want and store it in a seperate DB which I will then use for generating detailed graphs etc...
I currently do this by running a scipt on each host - which produces the following
Filename Tablespace # Mb # MaxMb #Mb Free % Free
----------------------------------- ------------ ------ ------- -------- ------
/u03/DBNAME/tbspace.dbf TBSPACE 10 20 0 3.2
Can this be extracted directly from the EMREP tables?
I'm currently looking at mgmt_v_db_tablespaces_ecm and mgmt$db_tablespaces but I was wondering if anyone with more knowledge could help me any further?
Thanks
R
*EDIT*
actually for clarity - all i want to extract is what is returned when the "Oracle Database Space Usage" report is run on a DB from Enterprise manager.
where is this information stored in the schema?
thanks
R
[Updated on: Tue, 02 March 2010 21:36] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
