Oracle Database - Session (Library|Cursor) Cache

1 - About

The library cache is a part of the shared pool

Also known as:

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

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap