>> Now when a run a 10046 level 12 trace on my test program (which does 1000 >> such inserts) I see that it executes the SELECT 1000 times but fetches >> 2000. >Mike, > > I don't know the answer to your question, but I would like to > see a snippet of the trace file showing the extra fetches. > > Jared Here's the snipet: SELECT my_clob FROM my_table WHERE id = :1 FOR UPDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1000 0.44 0.33 0 3000 1000 0 Fetch 2000 0.08 0.16 0 3000 0 1000 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3001 0.52 0.50 0 6000 1000 1000 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 66 -Mike ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------