Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Package vs standalone for single function/procedure?

Re: Package vs standalone for single function/procedure?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 4 Jan 2001 12:54:20 -0800
Message-ID: <932ntn$c0f$1@spiney.sierra.com>

I'm not absolutely sure about this, but I believe one can "pin" packages into memory but not procedures/functions.

"HOMES" <smullins_at_my-deja.com> wrote in message news:9306hb$qrl$1_at_nnrp1.deja.com...
> I've been told that placing a single function or procedure in a package
> will give better performance than writing a standalone function or
> procedure. Can someone confirm or refute? The argument was that a
> standalone will require all standalones to get loaded into memory,
> whereas the package will only require itself to be loaded. Sounds
> hokey, but I'd like to be sure. Any pointers to specific documentation
> would be great as well.
>
>
> Thanks.
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 04 2001 - 14:54:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US