| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
DBA_HIST_MUTEX_SLEEP displays mutex sleep summary historical statistics information.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
| SNAP_ID | NUMBER | NOT NULL | Unique snapshot ID | 
| DBID | NUMBER | NOT NULL | Database identifier for the snapshot | 
| INSTANCE_NUMBER | NUMBER | NOT NULL | Instance number for the snapshot | 
| MUTEX_TYPE | VARCHAR2(32) | NOT NULL | Mutex type | 
| LOCATION | VARCHAR2(40) | NOT NULL | The code location where the waiter slept for the mutex | 
| SLEEPS | NUMBER | Number of sleeps for this MUTEX_TYPEandLOCATION | |
| WAIT_TIME | NUMBER | Wait time in microseconds |