Oracle procedure load

[rawatds]

Hi
As per my understanding the whole concept of package is that it loaded itself in the memory when any procedure which is defined in the package is called.
is there any method which i can do or oracle itself loaded only that procedure in the memory rather then whole package
which is called and thus reduces the overhead.

Thanks and regards
rawat

 

[sem]

Package IS to be used to load a bunch of procedures. If you don't need this functionality just don't create a package and use a standalone procedure.
BTW do you experience any specific issues with loading the whole package? I mean that fanning your server may also increase its productivity and compensate package overhead

Regards, Dima

http://seminihin.narod.ru