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.
