Shared 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 […]