Databases Reference
In-Depth Information
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:
F
SQL_ID
: The identifier of the parent cursor in the library cache
F
SQL_TEXT
: The first thousand characters of the SQL text
F
SQL_FULLTEXT
: The full text of the SQL statement
F
USERS_EXECUTING
: The total number of users executing the statement
F
LOADS
: The number of times the object was loaded or reloaded
F
HASH_VALUE
: The hash value for the parent statement in the library cache
F
ADDRESS
: The address of the handle for the parent cursor
F
COMMAND_TYPE
: The Oracle command type definition
F
EXECUTIONS
: The number of executions that took place on this object since it
was brought into the library cache
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
See also
F
The
V$SQL
and
V$SQL_PLAN
recipes in this appendix
V$STATNAME
This view is used to decode a statistic identifier to its description.