Purpose
The GV$OB_OPT_STAT_GATHER_MONITOR view displays the real-time status of statistics collection tasks.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant to which the collection task belongs. |
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node where the collection task resides. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node where the collection task resides. |
| SESSION_ID | bigint(20) | NO | The ID of the session to which the collection task belongs. |
| TRACE_ID | varchar(64) | NO | The ID of the trace to which the collection task belongs. |
| TASK_ID | varchar(36) | NO | The ID of the collection task, which is generated based on the universally unique identifier (UUID) and is globally unique. |
| TYPE | varchar(16) | NO | The type of the collection task. |
| TASK_START_TIME | datetime(6) | NO | The start time of the collection task. |
| TASK_DURATION_TIME | bigint(20) | NO | The duration of the collection task, in microseconds. |
| TASK_TABLE_COUNT | bigint(20) | NO | The number of tables whose statistics need to be collected by the collection task. |
| COMPLETED_TABLE_COUNT | bigint(20) | NO | The number of tables whose statistics have been collected by the collection task. |
| RUNNING_TABLE_OWNER | varchar(128) | NO | The username of the owner of the table whose statistics are being collected by the collection task. |
| RUNNING_TABLE_NAME | varchar(256) | NO | The name of the table whose statistics are being collected by the collection task. |
| RUNNING_TABLE_DURATION_TIME | bigint(20) | NO | The duration that has been taken by the collection task to collect statistics of the table. |