[Home] [Help] [Dependency Information]
Object Name: | V_$SQL_PLAN_STATISTICS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDRESS | RAW | (8) | ||
HASH_VALUE | NUMBER | |||
SQL_ID | VARCHAR2 | (13) | ||
PLAN_HASH_VALUE | NUMBER | |||
FULL_PLAN_HASH_VALUE | NUMBER | |||
CHILD_ADDRESS | RAW | (8) | ||
CHILD_NUMBER | NUMBER | |||
OPERATION_ID | NUMBER | |||
EXECUTIONS | NUMBER | |||
LAST_STARTS | NUMBER | |||
STARTS | NUMBER | |||
LAST_OUTPUT_ROWS | NUMBER | |||
OUTPUT_ROWS | NUMBER | |||
LAST_CR_BUFFER_GETS | NUMBER | |||
CR_BUFFER_GETS | NUMBER | |||
LAST_CU_BUFFER_GETS | NUMBER | |||
CU_BUFFER_GETS | NUMBER | |||
LAST_DISK_READS | NUMBER | |||
DISK_READS | NUMBER | |||
LAST_DISK_WRITES | NUMBER | |||
DISK_WRITES | NUMBER | |||
LAST_ELAPSED_TIME | NUMBER | |||
ELAPSED_TIME | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ADDRESS
, HASH_VALUE
, SQL_ID
, PLAN_HASH_VALUE
, FULL_PLAN_HASH_VALUE
, CHILD_ADDRESS
, CHILD_NUMBER
, OPERATION_ID
, EXECUTIONS
, LAST_STARTS
, STARTS
, LAST_OUTPUT_ROWS
, OUTPUT_ROWS
, LAST_CR_BUFFER_GETS
, CR_BUFFER_GETS
, LAST_CU_BUFFER_GETS
, CU_BUFFER_GETS
, LAST_DISK_READS
, DISK_READS
, LAST_DISK_WRITES
, DISK_WRITES
, LAST_ELAPSED_TIME
, ELAPSED_TIME
, CON_ID
FROM SYS.V_$SQL_PLAN_STATISTICS;
|
|
|