Oracle Database - Session (Library|Cursor) Cache

> Database > Oracle Database

1 - About

The library cache is a part of the shared pool

Also known as:

Advertising

3 - How to

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

4 - Documentation / Reference