Re: Package Trade-offs??

_Her_ ???

"Mike Fotiou" <mfotiou_at_magma.ca> wrote in message news:crNu7.16437$5h5.8161576_at_news3.rdc2.on.home.com...
> Recently, our DBA recommended that we use packages as little as
> possible. Her primary concern was excessive memory usage
> because the entire package is loaded into memory the first time
> a call is made to one of its members.
>
> From what I have read, subsequent memory executions will
> actually increase performance.
>
> Does the memory overhead of packages prohibt their use in a
> multi-user environment? Is the solution as simple as ensuring
> that any packages created are kept as small as possible? What
> are the general guidelines, from Oracle and other users, for
> using packages.
>
>
Received on Thu Oct 04 2001 - 11:38:16 CEST