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 cacheSQL_TEXT
: The first thousand characters of the SQL textSQL_FULLTEXT
: The full text of the SQL statementEXECUTIONS
: The number of executions that took place on this object since it was brought into the library cacheINVALIDATIONS
: The number of times this child cursor has been invalidatedPARSE_CALLS
: The number of parse calls for this child cursorIS_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 ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.