V$SQL

This view lists statistics on shared SQL areas.

Fields

The most relevant view fields are as follows:

• SQL_ID: The identifier of the parent cursor in the library cache

• SQL_TEXT: The first thousand characters of the SQL text

• SQL_FULLTEXT: The full text of the SQL statement

• EXECUTIONS: The number of executions that took place on this object since it was brought into the library cache

• INVALIDATIONS: The number of times this child cursor has been invalidated

• PARSE_CALLS: The number of parse calls for this child cursor

• 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

• 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

• IS_SHAREABLE: This indicates whether the cursor can be shared (Y) or not (N)

See also

• The V$SESSION, V$SQL_PLAN, and V$SQLAREA sections in this appendix