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.
Oracle Session Manager is a software that allows you monitor and manage your oracle session.
In addition to these useful monitoring capabilities, OSM allows you to send LAN pop-up message to users of Oracle sessions.
Here are some key features of "Oracle Session Manager":
ï¿­ Capture all SQL statement text and archive to files in real time
ï¿­ Pinpoints problematic database sessions and displays detailed performance and resource consumption data.
ï¿­ Dynamically list sessions holding locks and other sessions who are waiting for.
ï¿­ Support to kill several selected sessions
ï¿­ Send LAN pop-up message to users of Oracle sessions
ï¿­ Gives hit/miss ratio for library cache,dictionary cache and buffer cache periodically,helps to tune memory
ï¿­ Export necessary data into file
ï¿­ Modify the dynamic system parameters on the fly
ï¿­ Syntax highlight for SQL statements
ï¿­ An overview of your current connected instance informaiton,such as Version, SGA,License,etc
ï¿­ Find out object according to File Id and Block Id
ï¿­ Support for Oracle 8.x
ï¿­ Access Oracle natively via Oracle Call Interface.No additional drivers or DLLs are needed to connect to an Oracle server.
Limitations:
ï¿­ 30 uses trial.