Process State Dump

To dump the process state use:

  ALTER SESSION SET EVENTS 
  'immediate trace name processstate level level';

For example:

  ALTER SESSION SET EVENTS 'immediate trace name processstate level 10';

The following ORADEBUG command has the same effect:

  ORADEBUG DUMP PROCESSSTATE level

The amount of library cache dump output for state object dumps can be limited using event 10065