Library Cache Dump
A library cache dump will have the details about the objects in the library cache, including the dependency structures and the details about the cursor, such as hash value and timestamp. This event can be used either with the immediate option, which dumps the library cache once the command is issued, or it can be triggered when an error occurs.
Syntax
Following methods show how to dump the library cache contents.
Using ALTER SESSION
The following ALTER SESSION command can be used to dump the library cache at level 10.
Using oradebug
The following oradebug commands can be used to produce an immediate dump of the library cache ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning 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.
