What Is a Shared Pool in Oracle

The shared pool is an area of Oracle memory that includes two main structures: The library cache, which stores parsed SQL and PL/SQL statements. The dictionary cache, which stores the Oracle data dictionary (or Oracle metadata)

What is the use of shared pool?

An important purpose of the shared pool is to cache the executable versions of SQL and PL/SQL statements. This enables multiple executions of the same SQL or PL/SQL code to be performed without the resources required for a hard parse, which results in significant reductions in CPU, memory, and latch usage.

What is shared pool size?

SHARED_POOL_SIZE specifies (in bytes) the size of the shared pool. The shared pool contains shared cursors, stored procedures, control structures, and other structures. If you set PARALLEL_AUTOMATIC_TUNING to false , then Oracle also allocates parallel execution message buffers from the shared pool.