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 |
...