Re: PL/SQL stored procedure performance questions
Date: 25 Jun 2002 08:29:51 +1000
Message-ID: <87u1nsux7k.fsf_at_blind-bat.une.edu.au>
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> writes:
> Limits are on DIANA nodes. Afaik there are no limits on source code
> size granted you have enough space in SYSTEM to fit it. So it's ok to
> group logically coherent procedures into single package.
>
The only thing I'd be very careful about is how you group things
together in packages. Oracle loads a whole package into memory, so the
number of packages loaded and how efficiently memory/caching is
depends on how your packages are structured - I think its often better
to have lots of small packages rather than a few large ones,
especially if your applications are not going to use all (or most) of
the procedures/functions which make up a large package.
Tim Received on Tue Jun 25 2002 - 00:29:51 CEST