Oracle Database - Shared sql area

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

• the cached SQL cursors
• the actual plan
• the parse tree

for a SQL statement.

Only one shared SQL area exists for a unique statement.

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

• How To Flush an Object out the Library Cache [SGA]