Sessions Manager facilities of the Server Administrator provide ability to analyze database sessions' activity by:

- Host

- Database

- Duration

- Locks Statistics

- I/O activity

 

Problematic sessions that create server bottlenecks can be easily terminated.

 

SQL statements last executed by any session can be captured for subsequent performance tuning with the help of the Execution Plan Analyzer.