Table of Contents

About

The library cache is a part of the shared pool

Oracle Database Sga

Also known as:

How to

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.

Documentation / Reference