Note
This view is available starting with V4.2.0.
Purpose
This view displays the real-time status of statistics collection tasks for the current tenant on the current OBServer node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER | NO | The ID of the tenant where the statistics collection task is located. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the node where the statistics collection task is located. |
| SVR_PORT | NUMBER | NO | The port of the node where the statistics collection task is located. |
| SESSION_ID | NUMBER | NO | The session ID of the statistics collection task. For V4.3.x:
|
| TRACE_ID | VARCHAR2(64) | NO | The TRACE ID of the statistics collection task. |
| TASK_ID | VARCHAR2(36) | NO | The ID of the statistics collection task (UUID, globally unique). |
| TYPE | VARCHAR2(16) | NO | The type of the statistics collection task. |
| TASK_START_TIME | TIMESTAMP(6) | NO | The start time of the statistics collection task. |
| TASK_DURATION_TIME | NUMBER | NO | The duration of the statistics collection task, in microseconds. |
| TASK_TABLE_COUNT | NUMBER | NO | The number of tables to be collected by the statistics collection task. |
| COMPLETED_TABLE_COUNT | NUMBER | NO | The number of tables that have been collected by the statistics collection task. |
| RUNNING_TABLE_OWNER | VARCHAR2(128) | NO | The username of the user who owns the table being collected by the statistics collection task. |
| RUNNING_TABLE_NAME | VARCHAR2(256) | NO | The name of the table being collected by the statistics collection task. |
| RUNNING_TABLE_DURATION_TIME | VARCHAR2(256) | NO | The duration of the table being collected by the statistics collection task. |
| RUNNING_TABLE_PROGRESS | VARCHAR2(256) | NO | The collection progress of the statistics collection task. |
Sample query
Query the real-time status of statistics collection tasks for the current tenant on the current node.
obclient> SELECT * FROM SYS.V$OB_OPT_STAT_GATHER_MONITOR;
The query result is as follows:
+-----------+----------------+----------+------------+-----------------------------------+--------------------------------------+---------------+----------------------------+--------------------+------------------+-----------------------+---------------------+--------------------+-----------------------------+
| TENANT_ID | SVR_IP | SVR_PORT | SESSION_ID | TRACE_ID | TASK_ID | TYPE | TASK_START_TIME | TASK_DURATION_TIME | TASK_TABLE_COUNT | COMPLETED_TABLE_COUNT | RUNNING_TABLE_OWNER | RUNNING_TABLE_NAME | RUNNING_TABLE_DURATION_TIME |
+-----------+----------------+----------+------------+-----------------------------------+--------------------------------------+---------------+----------------------------+--------------------+------------------+-----------------------+---------------------+--------------------+-----------------------------+
| 1006 | xxx.xxx.xxx.xx | 2882 | 3221575784 | YB42AC1E87C6-0005FF6AD9F825FB-0-0 | c921f339-1bc8-11ee-a7ea-52583362494c | MANUAL GATHER | 2023-07-06 14:46:07.691856 | 609652 | 1 | 0 | test | t1 | 609653 |
+-----------+----------------+----------+------------+-----------------------------------+--------------------------------------+---------------+----------------------------+--------------------+------------------+-----------------------+---------------------+--------------------+-----------------------------+
1 row in set
References
View the historical statistics collection status at the tenant level: DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
View the historical statistics collection status at the table level: DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
For more information about statistics collection monitoring and diagnostics, see Statistics collection monitoring and diagnostics.