excess rows processed

From: Stalin <stalinsk_at_gmail.com>
Date: Mon, 4 Jun 2007 09:23:39 -0700
Message-ID: <c5363d3a0706040923o4858096bofd57966adeed635a@mail.gmail.com>

Good Morning,

Any idea why rows processed is more than executions for dual query? Taken from from 10gR2 statspack snapshot for 1 hour period.

                                              CPU per    Elap per
 Executions   Rows Processed  Rows per Exec   Exec (s)   Exec (s)     SQL Id


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

   1,741,546       1,741,682            1.0       0.00        0.00 xnvyr270ynf25

SELECT 1 FROM DUAL Thanks
Stalin

PS. you might guessed it right, yes we use weblogic application.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 04 2007 - 11:23:39 CDT