I think this is what the MONITORING feature is used for. See http://technet.oracle.com/docs/produ...2a.htm#2056158 for details.

Anybody ever used monitoring?

Also, there is a script called catio.sql in your $OH/rdbms/admin directory that can help you with this also.