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 ...

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.