Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> excess rows processed
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 IdSELECT 1 FROM DUAL Thanks
------------ --------------- -------------- ---------- ----------- -------------
1,741,546 1,741,682 1.0 0.00 0.00 xnvyr270ynf25
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
![]() |
![]() |