INSERT..VALUES rows processed > executions
From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Thu, 9 Apr 2009 11:37:10 -0700 (PDT)
Message-ID: <752916.113.qm_at_web110104.mail.gq1.yahoo.com>
Date: Thu, 9 Apr 2009 11:37:10 -0700 (PDT)
Message-ID: <752916.113.qm_at_web110104.mail.gq1.yahoo.com>
Hi All,
I am looking at some INSERT INTO table VALUES (...) type queries in DBA_HIST_SQLSTAT where the rows_processed > executions.
Normally I'd expect to see 1-to-1 relation unless bulk binds are being used but the developers say they are not doing that. However I'm not allowed to see the code to confirm this.
Am I missing something obvious - are there any other circumstance where rows_processed > executions for an INSERT..VALUES? (No triggers on this table, not that it should matter). Oracle 10g on AIX.
Thanks!
Charlotte
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 09 2009 - 13:37:10 CDT