Welcome to OracleGiants.com!     

Oracle 10g DBA & Business Intelligence Resources.

Pin objects in Shared Pool

Frequently used procedures can (and generally should) be pinned in the shared pool.

Why: Frequently loading and reloading stored procedures, packages, and triggers into the shared pool is a relatively expensive operation for the server. By pinning packages in the shared pool, the amount of CPU used to reload packages will be minimized.

How to do it: To pin a package in the shared pool use the following command:
execute dbms_shared_pool.keep('SCHEMA.PACKAGE','P')

Note: Create a startup trigger to pin these packages whenever the database starts up.


Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.

Recent Posts

This site recommends Burleson Consulting for DBA Support & Consulting.

We are currently paying for accepted Oracle 10g DBA & Business Intelligence articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks.

Learn more

Editorial submissions & questions: editor@oraclegiants.com



This site is moderated by an:
Oracle Certified Professional
Oracle ACE


  Classic Car Online - The #1 spot for classic and muscle car enthusiats
2010 OracleGiants.com