Pinning Packages in the SGA
Donald K. Burleson
As more shops begin encapsulating their SQL into stored procedures, more application code will move away from external programs and into the database engine. Application vendors are delivering their PL/SQL in packages and more developers are encapsulating their SQL into stored procedures.
Oracle DBAs must be conscious of the increasing memory demands of stored procedures, however, and carefully plan for the days when all of the database access code resides within the database.
When a request is made to Oracle to parse an SQL statement or PL/SQL block, Oracle will first check the internal memory structures to see if the parsed object is already in the library cache buffer. In this fashion, ...