excess rows processed

  • From: Stalin <stalinsk@xxxxxxxxx>
  • To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 4 Jun 2007 09:23:39 -0700

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.
--
//www.freelists.org/webpage/oracle-l


Other related posts: