...
...
| Wait |  Image Added |
...
...
| Wait | The session is waiting on other Oracle locks, such as streams, latches, or internal locks. |
...
| STREAMS events; enqueue; other enq: events; latch activity; latch free; latch: events |
...
...
| Wait | | | | Info |
|---|
Enqueue may appear in Row Lock Wait and Table Lock Wait, depending on the values of the P1, P2, and P3 parameters. The Collector captures these parameters and assigns the wait state accordingly. This can be seen in the Current and Activity tabs. However, the Collect Instance Statistics PMDB process does not capture the parameters so that in the Statistics tab, the wait is always shown as Other Lock Wait. |
|
...
...
 Image Added |
...
...
...
...
...
...
| Waits | | Memory Wait | The session is waiting on a memory operation, such as page-in or page-out. This sub-state may also include memory-mapped I/O. |
...
| N/A |
| Operating System Waits |
...
 Image Added |
...
...
| Wait | The session is waiting on another type of OS operation, such as sorting. |
...
...
...
| Wait | The session is waiting on RAC or |
...
...
| DFS events; DLM events; gc events; gcs events; ges events; global events |
...
...
| Waits |  Image Added |
...
...
| Wait | The session is waiting on another, less common lock event. |
...
...
| Waits | | Rollback Segment Wait | The session is waiting on a rollback segment operation. |
...
| alter rbs offline; undo segment events |
| Commit & Checkpoint Waits |
...
 Image Added |
...
...
| Wait | The session is waiting on a redo log buffer operation. |
...
| log buffer space; log file syn |
| Commit & Checkpoint |
...
| Waits | | Log Switch and Clear Wait |
...
| The session is waiting for a log switch and clear operation to occur. |
...
| checkpoint events; log file switch events |
Oracle Server Wait
Parallel Query Server
Wait The session is waiting for a parallel query server to become available. PX create server; PX server shutdown; parallel query; create server; parallel query; dequeue wait
Oracle Server Wait Parallel Query Sync. Wait The session is waiting for a parallel query server to get synchronized with another parallel query server. Other PX events; other parallel query events
Sub-State Description Typical Oracle Events
Oracle Server Wait
Resource Mgr Wait The session is waiting for a resource to become available (only if the database resource manager is enabled). resmgr events
Oracle Server Wait [ Multi-Threaded Server
Wait The session is waiting for a
multi-threaded server to become available. alter system set dispatcher; alter system set mts_dispatcher
Oracle Server Wait
Background Process
Wait The session is waiting for an Oracle background process, such as DBWR or LGWR. LGWR events
Client Request Wait Request wait Request wait is generally considered as an idle event as the Oracle server process is waiting for the client process. Client messages
Communication Wait
Oracle/Oracle
Communication Wait The session is waiting for another Oracle instance, usually as a result of a DBLINK event or a standby database. SQL*Net break/reset to DBLINK; SQL*Net message from DBLINK; SQL*Net message to DBLINK; SQL*Net more data from DBLINK; SQL*Net more
data to DBLINK
Communication Wait Oracle/Client
Communication Wait The session is waiting for data sent to the client, usually as a result of a selected statement, or for data sent from a client, usually as a result of bind variables. SQL*Net break/reset to client; SQL*Net message to client; SQL*Net more data from client; SQL*Net more data to client
Internal Lock Wait
Shared Pool Wait The session is waiting for a shared pool operation. library cache load lock; library cache lock; library cache pin
Internal Lock Wait Buffer Wait The session is waiting for a buffer cache operation. buffer busy; buffer busy wait;
buffer latch
...
