Purpose
The GV$OB_DTL_INTERM_RESULT_MONITOR view displays the monitoring information about the DTL intermediate result manager.
Note
This view is introduced since OceanBase Database V3.2.4.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| TRACE_ID | VARCHAR2(64) | NO | The trace ID of the statement. |
| OWNER | VARCHAR2(64) | NO | The user of the intermediate result. |
| START_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the intermediate result was written. |
| EXPIRE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The expiration time of the intermediate result. |
| HOLD_MEMORY | NUMBER(38) | NO | The size of memory occupied. |
| DUMP_SIZE | NUMBER(38) | NO | The dump size. |
| DUMP_COST | NUMBER(38) | NO | The dump time consumed. |
| DUMP_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The dump point in time. |
| DUMP_FD | NUMBER(38) | NO | The file descriptor (FD) of the dump file. |
| DUMP_DIR_ID | NUMBER(38) | NO | The ID of the directory where the dump file is located. |
| CHANNEL_ID | NUMBER(38) | NO | The channel ID of DTL. |
| QC_ID | NUMBER(38) | NO | The query coordinator (QC) ID of the sender. |
| DFO_ID | NUMBER(38) | NO | The data flow operator (DFO) ID of the sender. |
| SQC_ID | NUMBER(38) | NO | The sub-query coordinator (SQC) ID of the sender. |
| BATCH_ID | NUMBER(38) | NO | The ordinal number in a batch in a Parallel Execution (PX) batch rescan scenario. |
| MAX_HOLD_MEMORY | NUMBER(38) | NO | The maximum size of occupied memory. |