Introduction to Waiting Events
Information about wait events is displayed in the following three dynamic performance views:
V$SESSION_WAIT: Displays the events that a session has just finished waiting for or is currently waiting for.V$SYSTEM_EVENT: Displays the total number of all pending events in the current tenant.V$SESSION_EVENT: Similar toV$SYSTEM_EVENT, but displays all wait events for each session.
Many wait events are related to internal implementations and may be subject to changes or removals. Please refer to the actual situation.
Event types
Every wait event belongs to a category. Wait events are mainly classified into the following types:
Type of the event to be waited for |
Wait Category Number ID |
Description |
|---|---|---|
| OTHER | 100 | Waiting Events Not Belonging to Other Types |
| APPLICATION | 101 | Wait Events Caused by Client Code |
| CONFIGURATION | 102 | Waiting Events Caused by Insufficient Database or Instance Resource Configuration |
| ADMINISTRATIVE | 103 | Wait Events Caused by Database Administrators' Command Input |
| CONCURRENCY | 104 | Wait events for internal database resources |
| COMMIT | 105 | Waiting Events Related to Log Commit |
| IDLE | 106 | A wait event that the session is in an inactive state and waiting for a task. |
| NETWORK | 107 | Network Communication-Related Waiting Events |
| USER_IO | 108 | I/O Wait Events |
| SYSTEM_IO | 109 | Waiting for I/O of Background Process Event |
| CLUSTER | 111 | Cluster-related wait events |
View Waiting Events
You can execute an SQL statement in the sys tenant to display all wait events in alphabetical order along with their corresponding wait event types. Example:
obclient> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;
Common wait events
Event Name |
Description |
Type of the event to be waited for |
Parameter 1 of waitevent |
Parameter 2 of the WAIT FOR EVENT statement |
Parameter 3 of WAIT FOR EVENTS |
|---|---|---|---|---|---|
| wait remove partition | Partition GC Waiting for Transaction Module Deletion | ADMINISTRATIVE | tenant_id | table_id | partition_id |
| wait end stmt | Wait for Statement End | CLUSTER | rollback | trans_hash_value | physic_plan_type |
| wait start stmt | Statement Wait Enabled | CLUSTER | trans_hash_value | physic_plan_type | participant_count |
| wait end trans | Transaction Commit Waiting | COMMIT | rollback | trans_hash_value | participant_count |
| async rpc proxy condition wait | Asynchronous RPC Wait Events Encapsulated by the Upper Layer | CONCURRENCY | address | - | - |
| dag worker condition wait | Background Dag Thread Waiting for Events | CONCURRENCY | address | - | - |
| latch: alive server tracer lock wait | Lock Wait for OBAliveServerMap Operations on the Status of OBServer in Memory | CONCURRENCY | address | number | tries |
| latch: alloc object lock wait | Lock Wait Events Internally Managed by OceanBase malloc for Small Blocks of Memory | CONCURRENCY | address | number | tries |
| latch: clog cascading info lock wait | Waiting Events for Clog Sub-Parent Cascade Module Lock | CONCURRENCY | address | number | tries |
| latch: clog locality lock wait | Lock for Protecting Internal Clog Locality Information | CONCURRENCY | address | number | tries |
| latch: clog task lock wait | Lock of log_task in the clog module | CONCURRENCY | address | number | tries |
| latch: config lock wait | Lock Wait Events | CONCURRENCY | address | number | tries |
| latch: default drw lock wait | DRWLock wait event. DRWLock is a read/write lock suitable for read-heavy, write-light workloads. | CONCURRENCY | address | number | tries |
| latch: default mutex wait | Default MUTEX Wait Event | CONCURRENCY | address | number | tries |
| latch: default recursive mutex wait | Default Recursive MUTEX Wait Event | CONCURRENCY | address | number | tries |
| latch: default spin lock wait | Default spin lock wait event | CONCURRENCY | address | number | tries |
| latch: default spin rwlock wait | Default Spin Read/Write Lock Wait Event | CONCURRENCY | address | number | tries |
| latch: id map node lock wait | ID map wait events. An ID map is used to map integers to pointers. | CONCURRENCY | address | number | tries |
| latch: server maintaince lock wait | Lock Wait During OBServer Operations on RS | CONCURRENCY | address | number | tries |
| latch: server status lock wait | Read and write lock waits when operating on the serverstatuses of RS records | CONCURRENCY | address | number | tries |
| latch: unit manager lock wait | Lock Wait for Unit Manager Operations | CONCURRENCY | address | number | tries |
| latch: zone infos rw lock wait | Lock Wait for OBZoneManagerBase Data Operations | CONCURRENCY | address | number | tries |
| latch: zone manager maintaince lock wait | Lock Wait for Data Operations by Zone Manager | CONCURRENCY | address | number | tries |
| partition table updater condition wait | Condition wait during task processing by OBUniqTaskQueue | CONCURRENCY | address | - | - |
| rebalance task mgr condition wait | Condition Wait of OBDRTaskMgr During Disaster Recovery Task Processing | CONCURRENCY | address | - | - |
| reentrant thread condition wait | Condition wait during task processing by OBReentrantThread | CONCURRENCY | address | - | - |
| rpc session handler condition wait | Stream RPC Waiting for Event | CONCURRENCY | address | - | - |
| th worker condition wait | Multi-Tenant Thread Suspension Waiting for Events | CONCURRENCY | address | - | - |
| thread idling condition wait | RootService Idle Thread Waiting Event | CONCURRENCY | address | - | - |
| sched idle | Multi-Tenant Thread Waiting for Task Execution | IDLE | wait start timestamp | - | - |
| mysql response wait client | Time Spent Waiting for Client Response | NETWORK | - | - | - |
| sync rpc | Synchronize RPC Waiting Events | NETWORK | pcode | size | - |
| sched wait | Multi-tenant threads are suspended due to large query execution | SCHEDULER | req type | req start timestamp | wait start timestamp |
| bloomfilter build read | Backend BloomFilter creates data read | SYSTEM_IO | fd | offset | size |
| db file compact read | Compaction Task Data Read | SYSTEM_IO | fd | offset | size |
| db file compact write | Data Written in Compaction Tasks | SYSTEM_IO | fd | offset | size |
| db file index build read | Index creation data read | SYSTEM_IO | fd | offset | size |
| db file index build write | Index creation and data writing | SYSTEM_IO | fd | offset | size |
| db file migrate read | Data Migration Read | SYSTEM_IO | fd | offset | size |
| db file migrate write | Data Migration Write | SYSTEM_IO | fd | offset | size |
| memstore memory page alloc wait | Wait Time Triggered by MemStore Write Throttling | SYSTEM_IO | cur_mem_hold | sleep_interval | cur_ts |
| db file data read | User data reading | USER_IO | fd | offset | size |
| interm result disk read | Intermediate result data read | USER_IO | fd | offset | size |
| interm result disk write | Intermediate result data write | USER_IO | fd | offset | size |
| row store disk read | Read Data from Stored SQL Operators | USER_IO | fd | offset | size |
| row store disk write | SQL operator data write to disk | USER_IO | fd | offset | size |
| build index scheduler condition wait | Waiting Time between Two DDL Task Schedules | CONCURRENCY | address | - | - |
| debug sync condition wait | Meaningful in ErrSim debug mode, meaningless in user scenarios | CONCURRENCY | address | - | - |
| inner connection pool condition wait | Condition Wait in Internal Connection Pool | CONCURRENCY | address | - | - |
| latch: bandwidth throttle lock wait | Lock Wait Due to Bandwidth Throttling | CONCURRENCY | address | number | tries |
| latch: default bucket lock wait | Wait Time for Bucket Lock, Unclassified | CONCURRENCY | address | number | tries |
| latch: election group trace recorder lock wait | Lock protecting election group trace statistics | CONCURRENCY | address | number | tries |
| latch: group migrate lock wait | Lock Wait During Batch Migration | CONCURRENCY | address | number | tries |
| latch: group migrate task lock wait | Task Lock Wait During Batch Migration | CONCURRENCY | address | number | tries |
| latch: io queue lock wait | Lock wait during I/O queue read | CONCURRENCY | address | number | tries |
| latch: migrate lock wait | Lock Wait During Migration | CONCURRENCY | address | number | tries |
| latch: multi tenant lock wait | Lock Wait in Multi-Tenant Management | CONCURRENCY | address | number | tries |
| latch: rebuild retry list lock wait | Waiting for a Rebuild Task | CONCURRENCY | address | number | tries |
| latch: session trace recorder lock wait | Lock Wait Recorded in Session Trace | CONCURRENCY | address | number | tries |
| latch: tenant lock wait | Lock waits managed within a tenant | CONCURRENCY | address | number | tries |
| latch: timezone lock wait | Tenant's timezone structure lock wait, locked during tenant operations | CONCURRENCY | address | number | tries |
| oblog part mgr schema version wait | The logic for Liboblog to wait for the schema version to refresh | CONCURRENCY | - | - | - |
| server object pool arena lock wait | Lock Wait in LOB Cache Structure | USER_IO | fd | offset | size |
| async commiting wait | Clog Async Commit Waiting Event | COMMIT | - | - | - |
| exec inner sql wait | INNER SQL Waiting Events | OTHER | wait inner sql class | inner session id | - |
| sync rpc | Synchronize RPC Waiting Events | NETWORK | pcode | size | - |
| sleep: wait refresh schema | Wait for Schema Refresh to Specified Version | CONFIGURATION | sleep_interval | schema_version | - |
| palf throttling sleep | Log Thread Throttling | USER_IO | sleep_interval | - | - |
| palf read | Log Thread Reads Logs | SYSTEM_IO | fd | offset | size |
| palf write | Log Thread Writes Logs | SYSTEM_IO | fd | offset | size |
| das wait remote response | SQL Distributed Execution: The Database Waits for the Remote DAS Task to Return the Result | NETWORK | - | - | - |
| wait for network request in queue | The database system has received a session request, but the request is waiting to be processed by a worker thread. | NETWORK | pcode | level | priority |
| retry: insufficient px worker wait | Retry caused by insufficient PX thread resources | CONFIGURATION | degree of parallel | number of px workers required | the total number of idle PX workers currently |
| retry: wait GTS ready | Retries Caused by Waiting for GTS Ready | CLUSTER | error code | ls leader addr | ls leader port |
| retry: wait replica readable | Retry due to unreadable replica | CLUSTER | ls_id | tablet_id | - |
| retry: wait schema cache load | Retries Caused by Loading Schema Cache | CLUSTER | error code | table id | table schema version |
| retry: wait location cache load | Retry Caused by Loading Location Cache | CLUSTER | error | ls_id | - |
| retry: other retry wait | Retries Due to Other Reasons | CLUSTER | error | - | - |
| row lock wait | Wait caused by a row lock | APPLICATION | lock holder tx id | data seq number | holder lock time |