Executions != Rows_Processed for single-row INSERT

From: Vsevolod Afanassiev <vafanassiev_at_yahoo.com>
Date: 14 May 2007 23:54:20 -0700
Message-ID: <1179212060.509731.271200@q75g2000hsh.googlegroups.com>

Hi,

I've noticed strange discrepancy in Oracle statistics: for particular singe-row INSERT statement
value of V$SQL statistics Executions != Rows_Processed. For example:

  INST_ID EXECUTIONS FIRST_LOAD_TIME ROWS_PROCESSED

---------- ---------- ------------------- --------------

SQL_TEXT

---

         1 480394 2007-05-11/03:33:04 3898236 INSERT INTO ec_journal (saveid, ip, jo_type, jo_process, jo_subprocess, jo_servi
ce, jo_function, jo_message_id, jo_request_time, jo_response_time,

jo_timediff,
jo_retries, jo_maxretries, jo_returncode, jo_errorcode,
jo_errormessage) VALUES

(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :
16)

         2 109531 2007-05-11/03:40:24 538666 INSERT INTO ec_journal (saveid, ip, jo_type, jo_process, jo_subprocess, jo_servi
ce, jo_function, jo_message_id, jo_request_time, jo_response_time,

jo_timediff,
jo_retries, jo_maxretries, jo_returncode, jo_errorcode,
jo_errormessage) VALUES

(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :
16)

The value in ROWS_PROCESSED is correct as we know how many rows gets inserted in this table per day.

All other frequently executed single-row insert statements have Executions = Rows_Processed.

This is 9.2.0.6.0 two-node RAC.

Thanks Received on Tue May 15 2007 - 01:54:20 CDT