Oracle Database - Shared sql area

> Database > Oracle Database

1 - 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.

Advertising

3 - How to

3.1 - see its content

  • 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.

4 - Documentation / Reference

db/oracle/shared_sql_area.txt · Last modified: 2017/09/06 22:18 by gerardnico