July 2015
Intermediate to advanced
288 pages
7h 26m
English
The single most common database administrative task that many people do is to investigate sessions. You might need to look into a session’s overall status, its locks, blocking locks, waits, current statement, explain plan, long operation status, and numerous other status or performance metrics. Sometimes this results in sessions having traces initiated or even being killed. In fact, earlier versions of Toad called this facility Trace/Kill. After it was augmented to handle all these scenarios and many others, however, this feature was renamed Session Browser. It’s quite probably one of the most used features of an administrative nature in Toad—and fortunately for many it’s part of the standard product (that is, it does not require ...