Oracle 11gR1
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 SQL plan for this cursor. Comparing one |
|
| 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 |
Note:
No comments:
Post a Comment