Table of Contents

About

The Shared sql area is an area in the library cache that contains:

for a SQL statement.

Only one shared SQL area exists for a unique statement.

Oracle Database Sga

How to

see its content

  • VSQL lists statistics on shared SQL areas.
  • 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.

Documentation / Reference