Oracle Database - Session (Library|Cursor) Cache

Card Puncher Data Processing

About

The library cache is a part of the shared pool

Oracle Database Sga

Also known as:

How to

get information on it

  • VSQL_PLAN contains the execution plan information for each child cursor loaded in the library cache.
  • VSQLAREA displays statistics on shared SQL areas and contains one row per SQL string. It provides statistics on SQL statements that are in memory, parsed, and ready for execution.
  • VSQL lists statistics on shared SQL areas.

Documentation / Reference




Recommended Pages
Card Puncher Data Processing
Oracle Database - Explain Plan from Cursor Cache (DBMS_XPLAN.DISPLAY_CURSOR)

This DBMS_XPLAN.DISPLAY_CURSOR function display the execution plan of an already executed statement where the resulting cursor...
Oracle Database Sga
Oracle Database - Shared Pool

The Shared pool is a shared memory area where cursors and PL/SQL objects are stored. The shared pool is a shared memory that store: Cached data dictionary information and Shared Cursors and PL/SQL...
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

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...
Oracle Database Sql Processing
SQL Engine - Hard Parse (Library cache miss)

During the sql parsing (which is a step of the sql processing), if the Database (for instance Oracle) cannot reuse existing code, then it must build a new executable version of the application code (ie...
Oracle Database Sql Processing
SQL Engine - Soft parse (Library cache hit)

A soft parse is any SQL parse that is not a hard parse. If the submitted statement is the same as a reusable SQL statement in the shared pool, then Oracle Database reuses the existing code. This reuse...



Share this page:
Follow us:
Task Runner