Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why Oracle always reparses anonymous blocks?
Hi, all!
When I opened v$sqlarea I saw that all anonumous PL/SQL blocks were
been always reparsed. If I exec the same block again, Oracle reparses
it again...
I call from anonymous blocks packages' procedures. And each reparsing
takes a redundant CPU resourse, I think. So, it's unreasonable.
How can I avoid redundant reparsing of identical anonymous PL/SQL blocks?
Thanks in advance. Received on Tue Dec 25 2001 - 06:06:19 CST