Shared Server State Dump

Oracle Shared Server was called Oracle Multithreaded Server in Oracle8 i Database and prior versions. Diagnosing the uncommon errors related to shared servers (such as process deadlocks) may warrant mtsstate or shared server state dumps, depending on the version of the database.

Syntax

Following methods show how to produce the shared server state dump.

Using ALTER SESSION

The first ALTER SESSION command below produces an immediate shared server state dump at level 10, while the second ALTER SESSION command produces the shared server state dump at level 1 when the session encounters ORA-0060 error.

 alter session set events 'immediate trace name shared_server_state level 10' 
 alter session set events '60 trace name shared_server_state level 1'; 

Using oradebug

Following oradebug command will produce an immediate shared server state dump at the supplied level.

 oradebug setmypid 
 oradebug unlimit 
 oradebug dump  shared_server_state <level> 

Controlling the Dump Information Using Levels

The various levels available to produce the shared server state dumps are listed here:

• Level 1 Dumps systemwide state only

• Level 2 Dumps queues

• Level 3 Dumps circuits on the service queue

• Level 4-6 Dumps dispatcher info

• Level 7-8 Dumps shared server info

• Level 9 Dumps inactive dispatcher and server slots

• Level 10-13 Dumps info on ‚“interesting ‚½ circuits

• Level 14+ Dump includes information about all circuits