Re: PL/SQL Package Question

In article <32EFFEAF.1C26_at_earthlink.net>, Richard Bolz <dbolz_at_earthlink.net> writes
>A small government contractor is concerned about the efficiency of
>packages. In particular, they are not using packages because "the
>entire package is loaded at the first reference and many of the package
>resources will not be used." Is this a common concern within the ORACLE
>community? On the surface it appears to be a 1960's type concern.
>Please help!!

On the surface it is a valid concern. If you have a large package taking up chunks of your shared pool and not being used then that is inefficient.

On the other hand, they seem to have misunderstood the use of packages. The whole point of packages is that they contain related code which is likely to be used together. If you design your entire application as a single package then you are asking for trouble.

On a very large system with lots of users (which is the only kind where this inefficiency really matters) there ought to be enough users doing various things to ensure that everything in the package gets used fairly frequently.

-- 
Jim Smith