Tag Archives: shared pool

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 »

Why pinning objects into the shared pool?

Last updated on November 14th, 2015 at 02:33 pmWhy pinning objects into the shared pool? What  is the pinning in Shared poolOracle Applications requires space in the ORACLE System Global Area (SGA) for stored packages and functions. If SGA space is fragmented, there may not be enough space to load a package or function. You should pre-allocate space in the SGA shared pool for packages, … Continue reading Why pinning objects into the shared pool? »