Is there any way to split all the stats by user (schema) when looking at the Performance tab in the Oracle 11g Enterprise Manager?

Enteprise Manager Performance tab (not my screenshot)

or effectively some other tool to retrieve that information - e.g. a running chart of #active sessions for user (that's probably easy by probing the v$session or similar). Or a running chart of I/O Megabytes per Second broken by user/schema.

1 Answer 1


You should be able to find what you're looking for by clicking the "Top Activity" link in the bottom right. When you get to the Top Activity page, try changing the drop down menu on the right side from "Top Sessions" to "Top Clients." You can then click on an individual user session to get more details about that session.

  • Thanks. I see there "100%" and no label next to it. If I scroll the time axis I see some marginal "0.6%" or similar for the Enterprise Manager session and rest the same. imgur.com/yK6L2f4 Commented Aug 13, 2015 at 9:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.