Originally posted by slimdave
Have you monitored the total number of loads though? If DBMS_PIPE is now pinned then I expect that other code is being aged out faster and suffering more loads. I'd try monitoring total loads, not just this one package.

From the Tom Kyte thread, this is the most interesting comment for me ...


It makes sense ... and if you pin a package then it has to be at the expense of others, right?
I agree with SlimDave. Which is usually a safe bet.

Originally posted by gandolf989
I haven't yet found a use for pinning objects. If you keep you code modular and efficient, reduce the number of hard parses, and make sure your sga is sized correctly, you should not need to pin anything. i.e. the less unique sql and pl/sql that hits your database the more likely it is to already be in memory. Think bind variables and bulk binding whenever possible.