Tag Archives: shared pool

Shared Pool decoded and Shared pool flush in Oracle database

Last updated on February 23rd, 2019 at 07:43 amShared pool is important memory structure in Oracle database system global area(SGA) Shared Pool in Oracle Decoded Shared pool in 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 check for the query first in the … Continue reading Shared Pool decoded and Shared pool flush in Oracle database »

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? »