Shared Server (MTS) Process Dump

To dump buffer headers and buffer contents for buffers currently in the cache:

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

where level is in the range 1 to 14

The following ORADEBUG command has the same effect:

  ORADEBUG DUMP SHARED_SERVER_STATE level

In Oracle 8.1.7 and below, this dump is called MTSSTATE