Those are two distinct objects and Oracle would need to keep track of both
in case one of them, or threir dependants, or the objects that those depend
on are changed. Their text commonality isn't really important cause you
could achieve this by using synonyms for different objects that the
procedures depend on.
On 4/6/06, Guang Mei <GMei_at_ph.com> wrote:
>
> Hi
> Oracle 9i or 10g.
> I have a question about how pl/sql program accessed in the shared pool
> memory. Let's say I have two schema owners (S1 and S2), and each of them
> has it's own procedure ProcXYZ. S1.ProcXYZ and S2.ProcXYZ are the same
> code (100% exact).
>
> 1. when ProcXYZ is called by S1 for the first time, oracle loads the
> pl/sql code into the shared pool, and let's say it satys there (not aged
> out) afterwards.
>
> 2. then S2 calls it's own ProcXYZ, when this happens, does oracle go to
> the shared pool and find the same code sits there (because it was called by
> S1) and use that, or oracle loads S2's own ProcXYZ and execute it, so we
> have two copies of ProcXYZ in shared pool ?
>
> Thanks.
>
> Guang
>
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Apr 16 2006 - 15:32:59 CDT
