Oracle Database - Shared sql area
About
The Shared sql area is an area in the library cache that contains:
- the cached SQL cursors
- the actual plan
- the wiki/parse tree
for a SQL statement.
Only one shared SQL area exists for a unique statement.
Articles Related
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.