Oracle Database - Session (Library|Cursor) Cache

About

The library cache is a part of the shared pool

Also known as:

How to

get information on it

  • V$SQL_PLAN contains the execution plan information for each child cursor loaded in the library cache.
  • V$SQLAREA 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.
  • V$SQL lists statistics on shared SQL areas.

Documentation / Reference


Powered by ComboStrap