Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How can I reduce parsing?
Hi,
my question deals with multi-processing (not -threading):
given a certain programm containing a certain SQL statement, which is run in n instances (individual connects); when inspecting the trace file, I see n times parsing the same statement. Why? Once the statement exists in the library cache, no further parses should occur. What is wrong?
Thanx, Peter Received on Mon Feb 14 2000 - 09:01:30 CST