V$SQLAREA

This view displays statistics on shared SQL areas, containing one row per SQL string.

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

• USERS_EXECUTING: The total number of users executing the statement

• LOADS: The number of times the object was loaded or reloaded

• HASH_VALUE: The hash value for the parent statement in the library cache

• ADDRESS: The address of the handle for the parent cursor

• COMMAND_TYPE: The Oracle command type definition

• 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

See also

• The V$SQL and V$SQL_PLAN recipes in this appendix