Re: Package Trade-offs??
Date: Sat, 06 Oct 2001 08:44:35 GMT
Message-ID: <913229F0Eadshoustonrrcom_at_24.28.95.150>
mfotiou_at_magma.ca (Mike Fotiou) wrote in <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.
>
>
suggest you get a new DBA!!! Have you checked the price of memory lately? Received on Sat Oct 06 2001 - 10:44:35 CEST