Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Are anonymous pl/sql blocks cached in the server?
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 - 16:01:00 CST