Re: Are anonymous pl/sql blocks cached in the server?

From: Fergus <sinhask_at_swbell.net>
Date: Wed, 23 Jan 2002 23:12:31 GMT
Message-ID: <zrH38.742$th2.332189733@newssvr30.news.prodigy.com>

Anonymous PL/SQL should be moved into a stored object when possible and

this object then pinned in the shared pool using dbms_shared_pool.keep() if the object is frequently referenced.

"Luis Cabral" <luiscabral99_at_ig.com.br> wrote in message news:c9ff1799.0201231400.2afd9709_at_posting.google.com...
> Hi
>
> I know that SQL commands are cached, in the case they need
> to be reexecuted. Does the same happens to anonymous pl/sql
> blocks? Or they need to be recompiled everytime they are run?
>
> Is there some configuration parameter that controls how this occurs?
>
> I am using oracle 8.1.7
>
> Thanks
> Luis Cabral
Received on Wed Jan 23 2002 - 17:12:31 CST