Overview
v$sql_plan_monitor displays operation-level statistics of slow queries. Each operation has one row.
Related tables/views
gv$sql_plan_monitor
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | BIGINT(20) | No | The ID of the tenant. |
| KEY | NULL | No | The external key. It can be used for joining virtual tables related to SQL_MONITOR. |
| STATUS | NULL | No | The status of the operator. Valid values: * EXECUTING: The operator is being executed. * DONE(ERROR): An error occurred during the execution of the operator. * DONE(FIRST N ROWS): The execution succeeded. * DONE(ALL ROWS): The execution succeeded. * DONE: The execution was interrupted. |
| SVR_IP | varchar(32) | No | The IP address of the server on which the operator is located. |
| SVR_PORT | BIGINT(20) | No | The port number of the server on which the operator is located. |
| TRACE_ID | varchar(64) | No | The trace ID of the operator. |
| FIRST_REFRESH_TIME | TIMESTAMP(6) | No | The time when the monitoring of the operator started. |
| LAST_REFRESH_TIME | TIMESTAMP(6) | No | The time when the monitoring of the operator ended. |
| FIRST_CHANGE_TIME | TIMESTAMP(6) | No | The time when the operator delivered the first row of data. |
| LAST_CHANGE_TIME | TIMESTAMP(6) | No | The time when the operator delivered the last row of data. |
| REFRESH_COUNT | NULL | No | The number of times the statistics data was refreshed. |
| SID | NULL | No | The ID of the session. |
| PROCESS_NAME | BIGINT(20) | No | The ID of the thread that executed the operator. |
| SQL_ID | NULL | No | The ID of the SQL request. |
| SQL_EXEC_START | NULL | No | The time when the execution of the SQL request started. |
| SQL_EXEC_ID | NULL | No | The ID of the SQL request execution. |
| SQL_PLAN_HASH_VALUE | NULL | No | The hash value of the SQL plan. |
| SQL_CHILD_ADDRESS | NULL | No | The default value of this field is NULL. |
| PLAN_PARENT_ID | NULL | No | The default value of this field is NULL. |
| PLAN_LINE_ID | BIGINT(20) | No | The default value of this field is NULL. |
| PLAN_OPERATION | varchar(128) | No | The operator in the execution plan. |
| PLAN_OPTIONS | NULL | No | The default value of this field is NULL. |
| PLAN_OBJECT_OWNER | NULL | No | The default value of this field is NULL. |
| PLAN_OBJECT_NAME | NULL | No | The default value of this field is NULL. |
| PLAN_OBJECT_TYPE | NULL | No | The default value of this field is NULL. |
| PLAN_DEPTH | BIGINT(20) | No | The depth of the operator in the plan tree. |
| PLAN_POSITION | NULL | No | The position of the operator among the operators that share the same parent operator. |
| PLAN_COST | NULL | No | The cost of executing the operator. This value is calculated by the optimizer. |
| PLAN_CARDINALITY | NULL | No | The number of rows that will be returned by the execution of the operator. This value is calculated by the optimizer. |
| PLAN_BYTES | NULL | No | The number of bytes that will be returned by the execution of the operator. This value is calculated by the optimizer. |
| PLAN_TIME | NULL | No | The estimated time that the execution of the operator will take. This value is calculated by the optimizer. |
| PLAN_PARTITION_START | NULL | No | The default value of this field is NULL. |
| PLAN_PARTITION_STOP | NULL | No | The default value of this field is NULL. |
| PLAN_CPU_COST | NULL | No | The estimated CPU cost of executing the operator. This value is calculated by the optimizer. |
| PLAN_IO_COST | NULL | No | The estimated I/O cost of executing the operator. This value is calculated by the optimizer. |
| PLAN_TEMP_SPACE | NULL | No | The space that the operator is estimated to consume. This value is calculated by the optimizer. |
| STARTS | BIGINT(20) | No | The number of times the operator has been rescanned. |
| OUTPUT_ROWS | BIGINT(20) | No | The total number of rows returned from all the executions of the operator. |
| IO_INTERCONNECT_BYTES | NULL | No | The number of bytes exchanged between the operator and the storage layer. |
| PHYSICAL_READ_REQUESTS | NULL | No | The total number of I/O read requests sent by the operator. |
| PHYSICAL_READ_BYTES | NULL | No | The total number of bytes in the I/O read requests sent by the operator. |
| PHYSICAL_WRITE_REQUESTS | NULL | No | The total number of I/O write requests sent by the operator. |
| PHYSICAL_WRITE_BYTES | NULL | No | The total number of bytes that the operator requested to write. |
| WORKAREA_MEM | NULL | No | The size of the workarea that the operator occupies in the memory. |
| WORKAREA_MAX_MEM | NULL | No | The maximum size of the workarea that the operator can occupy. |
| WORKAREA_TEMPSEG | NULL | No | The dump space that the operator occupies on the disk. |
| WORKAREA_MAX_TEMPSEG | NULL | No | The maximum size of the dump space that the operator can occupy on the disk. |
| OTHERSTAT_GROUP_ID | NULL | No | The default value of this field is NULL. |
| OTHERSTAT_1_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_1_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_1_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_2_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_2_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_2_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_3_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_3_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_3_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_4_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_4_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_4_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_5_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_5_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_5_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_6_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_6_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_6_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_7_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_7_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_7_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_8_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_8_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_8_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_9_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_9_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_9_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_10_ID | BIGINT(20) | No | Reserved for future use. |
| OTHERSTAT_10_TYPE | NULL | No | Reserved for future use. |
| OTHERSTAT_10_VALUE | BIGINT(20) | No | Reserved for future use. |
| OTHER_XML | NULL | No | Other structured data that need to be provided to the outside but cannot be written to the existing fields. The data in this field is intended to be parsed by external tools. |
| PLAN_OPERATION_INACTIVE | NULL | No | The default value of this field is NULL. |