Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Executions != Rows_Processed for single-row INSERT

Re: Executions != Rows_Processed for single-row INSERT

From: <yong321_at_yahoo.com>
Date: 16 May 2007 11:06:32 -0700
Message-ID: <1179338792.493288.22010@w5g2000hsg.googlegroups.com>


On May 15, 2:54 pm, Vsevolod Afanassiev <vafanass..._at_yahoo.com> wrote:
> 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

If rows_processed > executions, the SQL may be a bulk insert inside PL/ SQL. If the other way, the SQL may be failing due to runtime error, such as unique constraint violation.

Yong Huang Received on Wed May 16 2007 - 13:06:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US