Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The DBA_OB_DEADLOCK_EVENT_HISTORY view displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| EVENT_ID | NUMBER(38) | NO | The ID of the deadlock event. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the node participating in the deadlock event. |
| SVR_PORT | NUMBER(38) | NO | The port number on the node participating in the deadlock event. |
| DETECTOR_ID | NUMBER(38) | NO | The ID of the node participating in the deadlock event, which must be unique within the process. |
| REPORT_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The reporting time of the deadlock event based on the timestamp on the reporting server. |
| CYCLE_IDX | NUMBER(38) | NO | The number of the node in the deadlock cycle. |
| CYCLE_SIZE | NUMBER(38) | NO | The number of nodes participating in the deadlock event. |
| ROLE | CLOB | NO | The role that the node plays in the deadlock event. Valid values: |
| PRIORITY_LEVEL | CLOB | NO | The level of priority of the node. Valid values: |
| PRIORITY | NUMBER(38) | NO | The priority value that the node has. When the priorities are the same, the priority values are checked, and the node with the lowest priority value in the cycle is evicted. |
| CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the node was created. |
| START_DELAY_US | NUMBER(38) | NO | The interval between the node creation time and the time when deadlock detection starts. Unit: ms. |
| MODULE | CLOB | NO | The module where the node resides, such as transaction. |
| VISITOR | CLOB | NO | The resource visitor represented by the node, such as trans_id. |
| OBJECT | CLOB | NO | The resource that the node requests for, such as row_key. |
| EXTRA_NAME1 | CLOB | YES | The name of additional information 1 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_VALUE1 | CLOB | YES | The content of additional information 1 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_NAME2 | CLOB | YES | The name of additional information 2 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_VALUE2 | CLOB | YES | The content of additional information 2 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_NAME3 | CLOB | YES | The name of additional information 3 that the upper layer wishes to add to the deadlock report event. |
| EXTRA_VALUE3 | CLOB | YES | The content of additional information 3 that the upper layer wishes to add to the deadlock report event. |
