Purpose
The DBA_OB_TENANT_EVENT_HISTORY view displays the historical operation records of the current tenant.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TIMESTAMP | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the operation was executed, in microseconds. |
| MODULE | VARCHAR2(256) | NO | The name of the module. |
| EVENT | VARCHAR2(256) | NO | The name of the event. |
| NAME1 | VARCHAR2(256) | YES | The name of the first attribute. |
| VALUE1 | CLOB | YES | The value of the first attribute. |
| NAME2 | VARCHAR2(256) | YES | The name of the second attribute. |
| VALUE2 | CLOB | YES | The value of the second attribute. |
| NAME3 | VARCHAR2(256) | YES | The name of the third attribute. |
| VALUE3 | CLOB | YES | The value of the third attribute. |
| NAME4 | VARCHAR2(256) | YES | The name of the fourth attribute. |
| VALUE4 | CLOB | YES | The value of the fourth attribute. |
| NAME5 | VARCHAR2(256) | YES | The name of the fifth attribute. |
| VALUE5 | CLOB | YES | The value of the fifth attribute. |
| NAME6 | VARCHAR2(256) | YES | The name of the sixth attribute. |
| VALUE6 | CLOB | YES | The value of the sixth attribute. |
| EXTRA_INFO | CLOB | YES | The additional information. |
| SVR_IP | VARCHAR2(46) | YES | The IP address of the OBServer node on which the operation was executed. |
| SVR_PORT | NUMBER(38) | YES | The port number of the OBServer node on which the operation was executed. |
| TRACE_ID | VARCHAR2(64) | YES | The trace ID of the operation. |
| COST_TIME | NUMBER(38) | YES | The time taken to execute the operation. |
| RET_CODE | NUMBER(38) | YES | The error code for the operation. The value 0 indicates that the operation was successfully executed. |
| ERROR_MSG | VARCHAR2(512) | YES | The error message. |