Dictionary cache

Shared Pool in Oracle and Shared pool flush in Oracle database

February 3, 2023 by techgoeasy 2 Comments

A shared pool is an important memory structure in Oracle database system global area(SGA) What is Shared Pool in Oracle The shared pool in the Oracle database is the place where Oracle caches the SQL, PL/SQL and dictionary data. Whenever we parse a query, the parsed representation is cached there and it is shared also. Oracle […]