Chapter 60
Oracle Sessions Monitoring
Serg Shestakov
Dmitry Petrov
One of the most challenging tasks for an Oracle DBA is to keep an eye on sessions. Standard Oracle tools aimed at solving this problem are rather heavyweighted, and it is not that easy to deploy and customize these tools for particular DBA needs. It is good practice for a DBA to write scripts for sessions monitoring. Sometimes there can be a situation when graphical tools like Top Sessions Monitor cannot be used; all that is left for a DBA may be just a UNIX command console. More importantly, when writing these scripts, the DBA gets a clear understanding of how to work with the Oracle dictionary structures responsible for storing vital sessions information — what resources are ...
Get Oracle Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
