Oracle Session Manager

Oracle Session Manager is a tool for monitoring how connected sessions use database instance resources in real time.

You can obtain an overview of session activity sorted by a statistic of your choosing. For any given session, you can then drill down for more detail. You can further customize the information you display by specifying manual or automatic data refresh, the rate of automatic refresh.