9.60 V$SQL_PLAN_STATISTICS
V$SQL_PLAN_STATISTICS
provides execution statistics at the row source level for each child cursor.
Column | Datatype | Description |
---|---|---|
|
|
Address of the handle to the parent for this cursor |
|
|
Hash value of the parent statement in the library cache. The two columns |
|
|
SQL identifier of the parent statement in the library cache |
|
|
Numerical representation of the current SQL plan for this cursor. Comparing one |
|
|
Numeric representation of the complete SQL plan for this cursor. Comparing one |
|
|
Address of the child cursor |
|
|
Number of the child cursor that uses this work area. The columns |
|
|
A number assigned to each step in the execution plan |
|
|
Number of times this cursor has been executed |
|
|
Number of times this operation has been started, during the last execution |
|
|
Number of times this operation has been started, accumulated over the past executions |
|
|
Number of rows produced by the row source, during the last execution |
|
|
Number of rows produced by the row source, accumulated over the past executions |
|
|
Number of buffers retrieved in consistent mode, during the last execution. Buffers are usually retrieved in consistent mode for queries. |
|
|
Number of buffers retrieved in consistent mode, accumulated over the past executions. Buffers are usually retrieved in consistent mode for queries. |
|
|
Number of buffers retrieved in current mode, during the last execution. Buffers are retrieved in current mode for statements such as |
|
|
Number of buffers retrieved in current mode, accumulated over the past executions. Buffers are retrieved in current mode for statements such as |
|
|
Number of physical disk reads performed by the operation, during the last execution |
|
|
Number of physical disk reads performed by the operation, accumulated over the past executions |
|
|
Number of physical disk writes performed by the operation, during the last execution |
|
|
Number of physical disk writes performed by the operation, accumulated over the past executions |
|
|
Elapsed time (in microseconds) corresponding to this operation, during the last execution |
|
|
Elapsed time (in microseconds) corresponding to this operation, accumulated over the past executions |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: