Oracle: Shared SQL Area

The shared SQL area stores an SQL statement's execution plan which is the same for all sessions that execute this SQL statement.

Data that cannot be shared by sessions that use the SQL statement are in the private SQL area. Such data are for example the values of bind variables.

The shared SQL area is part of the library cache.

The shared SQL area is sometimes referred to as cursor cache.