V$MUTEX_SLEEP_HISTORY displays time-series data. Each row in this view is for a specific time, mutex type, location, requesting session and blocking session combination. That is, it shows data related to a specific session (requesting session) that slept while requesting a specific mutex type and location, because it was being held by a specific blocking session. The data in this view is contained within a circular buffer, with the most recent sleeps shown.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Mutex ID |
|
|
|
The last date/time this |
|
|
|
Type of action/object the mutex protects |
|
|
|
The total number of gets since the mutex was created and up until the time of the wait (and from all sessions past and present) |
|
|
|
The number of times the requester had to sleep before obtaining the mutex |
|
|
|
The SID of a session requesting the mutex |
|
|
|
The SID of a session holding the mutex |
|
|
|
The code location where the waiter slept for the mutex |
|
|
|
If the mutex is held in exclusive (X) mode, this column shows the SID of the blocking session, else it shows the number of sessions referencing the mutex in S mode. |
|
|
|
Reserved for internal use |
|
|
|
Reserved for internal use |
|
|
|
Reserved for internal use |
|
|
|
Reserved for internal use |
|
|
|
Reserved for internal use |
|
|
|
Reserved for internal use |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|