[Announcement]New features in a session and sql manager tool [message #106288] |
Thu, 30 January 2003 23:15 |
Gudu Software
Messages: 8 Registered: September 2002
|
Junior Member |
|
|
New features in Oracle Session Manager:
It is not so easy to capture sql in web based application, there is an article at
http://www.wangz.net/ntiersql.php demostrates how to achieve it.
and Oracle Session Manager now supports to capture sql in such application.
Other features:
--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
Get Oracle Session Manager at http://www.wangz.net
Gudu Software
http://www.wangz.net
|
|
|