Tag Archives: Dictionary cache

Shared Pool decoded and Shared pool flush

Last updated on August 27th, 2016 at 05:04 pmShared pool is important memory structure in Oracle database system global area(SGA)  Shared Pool Decoded -Text of the SQL or PL/SQL statement -Parsed form of the SQL or PL/SQL statement -Execution plan for  the SQL or PL/SQL statements -Data dictionary cache containing rows of data dictionary information It consists of  Library cache and Dictionary cache primarily Library Cache -shared … Continue reading Shared Pool decoded and Shared pool flush »