Dynamic Performance Views - Oracle Database 11gR2 Performance Tuning - page 489

F INVALIDATIONS : The number of times this child cursor has been invalidated
F PARSE_CALLS : The number of parse calls for this child cursor
F IS_BIND_SENSITIVE : This indicates whether the cursor is bind sensitive ( Y ) or not
( N ). A query is considered bind-sensitive if the optimizer peeked at one of its bind
variable values when computing predicate selectivity and where a change in a bind
variable value may cause the optimizer to generate a different plan
F IS_BIND_AWARE : This indicates whether the cursor is bind aware ( Y ) or not ( N ); a
query is considered bind-aware if it has been marked to use extended cursor sharing
F IS_SHAREABLE : This indicates whether the cursor can be shared ( Y ) or not ( N )
See also
F The V$SESSION , V$SQL_PLAN , and V$SQLAREA sections in this appendix
V$SQL_PLAN
This view contains information on execution plans for each child cursor loaded in the
library cache.
Fields
The most relevant view fields are as follows:
F OPERATION : The name of the internal operation performed in the step
F OBJECT_OWNER : The owner of the object (table or index)
F OBJECT_NAME : The name of the object (table or index)
F HASH_VALUE : The hash value of the parent statement in the library cache
F SQL_ID : The SQL identifier of the parent cursor in the library cache
F PLAN_HASH_VALUE : The hash value representing the SQL plan for the cursor,
useful to compare two plans
See also
The V$SQL and V$SQLAREA sections in this appendix