Chapter 40

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, ...

Get Oracle Internals now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.