Page History
...
| In Oracle State | Icon | In Oracle Sub-State | Description | Typical Oracle Events | ||
|---|---|---|---|---|---|---|
| Using CPU |  | Using CPU | The session is using CPU executing SQL. | N/A | ||
| I/O Wait | Direct I/O Wait | The session is waiting on direct I/O. | direct path read; direct path write | |||
| I/O Wait |  | Scattered I/O Wait | The session is waiting on scattered I/O. | db file scattered read | ||
| I/O Wait | Sequential I/O Wait | the session is waiting on sequential I/O. | db file sequential read; control file sequential read | |||
| I/O Wait | | Other I/O Wait | the session is waiting on another type of I/O. | db file parallel write; log file parallel write; control file parallel write; asynch disk I/O | ||
| I/O Wait |
| |||||
| Application Lock Wait |  | Row Lock Wait | the session is waiting on row locks. Enq: TX - row lock contention (Oracle 10g) | |||
| Application Lock Wait | Table Lock Wait | The session is waiting on table locks. | Enq: TM - contention (Oracle 10g) | |||
| Internal Lock Wait |  | Other Lock 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 | ||
| Application Lock Wait |
| |||||
| Operating System Waits |  | CPU Wait | The session is in the operating system queue waiting for CPU. | N/A | ||
| Operating System 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 |  | Other Host Wait | The session is waiting on another type of OS operation, such as sorting. | N/A | ||
| RAC/OPS/ Other Waits | RAC/OPS Wait | The session is waiting on RAC or OPS synchronization. | DFS events; DLM events; gc events; gcs events; ges events; global events | |||
| RAC/OPS/ Other Waits |  | Other Wait | The session is waiting on another, less common lock event. | N/A | ||
| Commit & Checkpoint Waits | Rollback Segment Wait | The session is waiting on a rollback segment operation. | alter rbs offline; undo segment events | |||
| Commit & Checkpoint Waits |  | Redo Log Buffer 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 |
...
| Oracle Server Wait |  | Resource Manager 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 |
| Anchor | ||||
|---|---|---|---|---|
|
...