SQL plans for current executing statements
(INST_ID, SQL_ID, CHILD_NUMBER, ID)
| Name | Data Type | Description |
|---|---|---|
| INST_ID | long | Instance ID |
| SQL_ID | string(16) | SQL ID |
| PLAN_HASH_VALUE | double | Hash value for the SQL plan |
| CHILD_NUMBER | long | Child # for the SQL; one SQL statement may have multiple child cursors due to environment differences between sessions |
| ID | long | ID # of the SQL plan step |
| PARENT_ID | long | Parent ID # of the SQL plan step |
| DEPTH | long | Depth, or level, of the SQL plan step; 0 = root step |
| FULL_PLAN_HASH_VALUE | double | Hash value for the full SQL plan (including adaptive nodes); can be used to compare two query plans, in the same instance, in version 12.1 or later |
| QUERY_PLAN | string(256) | Text of the SQL plan step |
| LAST_ELAPSED_TIME_PCT | double | % of total elapsed time, in last execution; use this to find bottlenecks in the query plan |
| LAST_ELAPSED_TIME | double | Elapsed time, in microseconds, of last execution |
| ELAPSED_TIME_PCT | double | % of total elapsed time, since instance started; use this to find bottlenecks in the query plan |
| ELAPSED_TIME_SECONDS | long | Elapsed time, in seconds, since instance started |
| LAST_OUTPUT_ROWS | double | Number of output rows for the SQL plan step, in the last execution |
| OUTPUT_ROWS | double | Number of output rows for the SQL plan step, since instance started |
| LAST_CR_BUFFER_GETS | double | Number of consistent-read (CR) buffer gets, in the last execution |
| CR_BUFFER_GETS | double | Number of consistent-read (CR) buffer gets, since instance started |
| LAST_CU_BUFFER_GETS | double | Number of current (CU) buffer gets, in the last execution |
| CU_BUFFER_GETS | double | Number of current (CU) buffer gets, since instance started |
| LAST_DISK_READS | double | Number of physical disk reads, in the last execution |
| DISK_READS | double | Number of physical disk reads, since instance started |
| LAST_DISK_WRITES | double | Number of physical disk writes, in the last execution |
| DISK_WRITES | double | Number of physical disk writes, since instance started |
| LAST_TEMPSEG_SIZE | double | Size, in bytes, of temp segment, in the last execution |
| MAX_TEMPSEG_SIZE | double | Maximum size, in bytes, of temp segment, since instance started |
| LAST_MEMORY_USEDB | double | Memory used, in bytes, in the last execution |
| ESTIMATED_OPTIMAL_SIZEB | double | Estimate of the optimal memory size, in bytes, since instance started |
| COST | double | Internal cost estimate of the SQL plan step |
| CARDINALITY | double | Internal cardinality (number of output rows) estimate of the SQL plan step |
| BYTES | double | Internal estimate of the output size, in bytes, of the SQL plan step |
| TEMP_SPACE | double | Internal estimate of the temp space, in bytes, of the SQL plan step |
| ACCESS_PREDICATES | string(256) | Access predicates |
| FILTER_PREDICATES | string(256) | Filter predicates |
| Attributes: | None |
|---|---|
| Minimum database version: | 9.2 |