Oracle Database - V$SQLAREA

Card Puncher Data Processing

About

VSQLAREA displays statistics on shared SQL areas and contains:

  • one row per SQL string.
  • ie one row per cursor parent.

It provides statistics on SQL statements that are in memory, parsed, and ready for execution.

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - Adaptive Plan

Adaptive plan is an adaptive functionality. The Adaptive plan functionality enables the optimizer to: generate multiple predetermined subplans defer the subplan decision until execution time based...
Oracle Database Sga
Oracle Database - Session (Library|Cursor) Cache

The library cache is a part of the shared pool Private Sql Area Also known as: Session cursor cache. V contains the execution plan information for each child cursor loaded in the library...
Oracle Database Sga
Oracle Database - Shared sql area

The Shared sql area is an area in the library cache that contains: the cached SQL cursors the actual plan the parse tree for a SQL statement. Only one shared SQL area exists for a unique statement....
Card Puncher Data Processing
Oracle Database - V$SQL_PLAN_STATISTICS

V provides execution statistics at the row source level for each child cursor. STATISTICS_LEVEL Join Column Equality Predicate Join...
Card Puncher Data Processing
Oracle Database - V$SQL_PLAN

V contains the actual execution plan information for each child cursor loaded in the library cache. library cache Join Column Equality Predicate Join Table In order to add ADDRESS and HASH_VALUE...
Card Puncher Data Processing
Oracle Database - V$SQL_WORKAREA

V displays information work areas used by SQL cursors. The primary key for the view is WORKAREA_ADDRESS, the memory Address...
Card Puncher Data Processing
PL/SQL - Cursor

A cursor in the context of Oracle. A cursor is a SQL datatype. A cursor is a pointer to a private SQL area that stores information processing a specific: SELECT or DML statement. The cursor data...



Share this page:
Follow us:
Task Runner