Anonymous PL/SQL can be pined as well by
dbms_shared_pool.keep(address.hash_value)
address and hash_value can be got from v$sqlarea
"Fergus" <sinhask_at_swbell.net> wrote in message
news:zrH38.742$th2.332189733_at_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 - 20:42:50 CST
