DBA Data[Home] [Help]

VIEW: SYS.V_$SQL_CS_STATISTICS

Source

View Text - Preformatted

select "ADDRESS","HASH_VALUE","SQL_ID","CHILD_NUMBER","BIND_SET_HASH_VALUE","PEEKED","EXECUTIONS","ROWS_PROCESSED","BUFFER_GETS","CPU_TIME","CON_ID" from v$sql_cs_statistics
View Text - HTML Formatted

SELECT "ADDRESS"
, "HASH_VALUE"
, "SQL_ID"
, "CHILD_NUMBER"
, "BIND_SET_HASH_VALUE"
, "PEEKED"
, "EXECUTIONS"
, "ROWS_PROCESSED"
, "BUFFER_GETS"
, "CPU_TIME"
, "CON_ID"
FROM V$SQL_CS_STATISTICS