The library cache is a part of the shared pool
- Private Sql Area
Also known as:
- Session cursor cache.
get information on it
- VSQL_PLAN contains the execution plan information for each child cursor loaded in the library cache.
- VSQLAREA 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.
- VSQL lists statistics on shared SQL areas.