Re: shared pool question

In this case, you will have two copies. The object is named by
"schema.object" notation. To Oracle, "schema1.proc1" and "schema2.proc1"
are two different objects even though they may share the exact same code.

Additionally, unless you are using envoker's rights, the two objects will be compiled with definer's rights, which for two different schemas, may mean two different privilege sets. So Oracle will treat these as different.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.




"I can give it to you cheap, quick, and good.

Now pick two out of the three" - Unknown