Database Monitor (Tree) |
|
JDBA Tool provides monitoring functions that allow you to view the status of individual user connections, transactions, and upper memory handling. The statistics provided by the monitoring functions can be useful for database performance evaluation and tuning. There are four main database-monitoring functions provided by JDBA Tool: Session information, Lock status, Database status, and Pending Transaction status.
Session information Monitoring Database Sessionsshows all connections with the database (users, backup demon, IO daemon...), and information related to the connection. Sessions can be terminated by the DBA with the Kill connection function.
Lock status Monitoring Database Locksis for viewing database objects that have locks on them, and the type of lock on the object.
Database status Monitoring Database Statusallows the DBA to view statistics relating to journal files and buffers, as well as view the current database setup.
Pending Transaction status Monitoring Pending Transactionsprovides information on distributed transactions that have been prepared to commit but have not been committed yet. Monitoring a Database
Related topic: