../E40402-16.epub /> ../E40402-16.mobi />

V$SQL_PLAN_STATISTICS

V$SQL_PLAN_STATISTICS provides execution statistics at the row source level for each child cursor.

Column Datatype Description
ADDRESS RAW(4 | 8) Address of the handle to the parent for this cursor
HASH_VALUE NUMBER Hash value of the parent statement in the library cache. The two columns ADDRESS and HASH_VALUE can be used to join with V$SQLAREA to locate the parent cursor.
SQL_ID VARCHAR2(13) SQL identifier of the parent statement in the library cache
PLAN_HASH_VALUE NUMBER Numerical representation of the SQL plan for this cursor. Comparing one PLAN_HASH_VALUE to another easily identifies whether or not two plans are the same (rather than comparing the two plans line by line)
CHILD_ADDRESS RAW(4 | 8) Address of the child cursor
CHILD_NUMBER NUMBER Number of the child cursor that uses this work area. The columns ADDRESS, HASH_VALUE, and CHILD_NUMBER can be used to join with V$SQL to locate the child cursor using this area.
OPERATION_ID NUMBER A number assigned to each step in the execution plan
EXECUTIONS NUMBER Number of times this cursor has been executed
LAST_STARTS NUMBER Number of times this operation has been started, during the last execution
STARTS NUMBER Number of times this operation has been started, accumulated over the past executions
LAST_OUTPUT_ROWS NUMBER Number of rows produced by the row source, during the last execution
OUTPUT_ROWS NUMBER Number of rows produced by the row source, accumulated over the past executions
LAST_CR_BUFFER_GETS NUMBER Number of buffers retrieved in consistent mode, during the last execution. Buffers are usually retrieved in consistent mode for queries.
CR_BUFFER_GETS NUMBER Number of buffers retrieved in consistent mode, accumulated over the past executions. Buffers are usually retrieved in consistent mode for queries.
LAST_CU_BUFFER_GETS NUMBER Number of buffers retrieved in current mode, during the last execution. Buffers are retrieved in current mode for statements such as INSERT, UPDATE, and DELETE.
CU_BUFFER_GETS NUMBER Number of buffers retrieved in current mode, accumulated over the past executions. Buffers are retrieved in current mode for statements such as INSERT, UPDATE, and DELETE.
LAST_DISK_READS NUMBER Number of physical disk reads performed by the operation, during the last execution
DISK_READS NUMBER Number of physical disk reads performed by the operation, accumulated over the past executions
LAST_DISK_WRITES NUMBER Number of physical disk writes performed by the operation, during the last execution
DISK_WRITES NUMBER Number of physical disk writes performed by the operation, accumulated over the past executions
LAST_ELAPSED_TIME NUMBER Elapsed time (in microseconds) corresponding to this operation, during the last execution
ELAPSED_TIME NUMBER Elapsed time (in microseconds) corresponding to this operation, accumulated over the past executions