Home » RDBMS Server » Enterprise Manager » custom query on EMREP SCHEMA (Enterprise Manager)
custom query on EMREP SCHEMA [message #445597] Tue, 02 March 2010 21:34
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?



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?



[Updated on: Tue, 02 March 2010 21:36]

Report message to a moderator

Previous Topic: EM console - Could not start the OracelDBConsoleSID service
Next Topic: Shared Memory Realm Does not Exist
Goto Forum:

Current Time: Thu Dec 09 01:53:00 CST 2021