Oracle Database - Session (Library|Cursor) Cache

The library cache is a part of the shared pool

• Oracle Database - Shared sql area
• Private Sql Area

Also known as:

• Session cursor cache.

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

• How To Flush an Object out the Library Cache [SGA]