Oracle Database - Session (Library|Cursor) Cache
Table of Contents
1 - About
The library cache is a part of the shared pool
- Private Sql Area
Also known as:
- Session cursor cache.
2 - Articles Related
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.