Processstate Dump
Processstate dumps are usually required to collect more information when diagnosing memory corruptions or dead lock errors. Processstate dumps also show the details about the shared objects used by the library cache and help in determining the process. This is very helpful in diagnosing the hanging or looping conditions. The dump can be initiated immediately or set to occur when the errors happens. Immediate invocation is not very common.
Syntax
The following methods show how to produce a processstate dump.
Using ALTER SESSION
The first ALTER SESSION command below produces an immediate processstate dump at level 10 while the second ALTER SESSION command produces the dump when the session encounters an ORA-4020 error.
Using ...
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.
