Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> High hard parse and version counts for dbms_lob functions
OS: Solaris 8
Oracle: 8.1.5.0
While running a tkprof off of a 10046 level 12 tracefile, I noticed that each and every parse of all the dbms_lob functions (e.g., getchunksize(), read(), write(), etc.) are hard parses.
On the getchunksize() calls, it gets hard parsed for every execute. For the read() calls, exactly 50% of the total executions resulted in hard parses. Lastly, for all the write() calls, 90% of the total executions resulted in hard parses.
Every call makes use of bind variables. The version counts for these statements are each into the single digit thousands.
While I'm aware of the 8.1.5 bug with timed_statistics=true, I notice in the same tkprof output that all other SQL that makes use of bind vars (e.g., select, insert, update, delete) parses once and executes many.
Is there anything that I'm missing here? Should this be so for the dbms_lob package functions? Is this to be expected if LOBS are used such that they are stored out-of-line from the table and in a separate LOB segment?
Thanks in advance for your help. Received on Thu May 01 2003 - 13:46:01 CDT