RE: Long execute phase for SELECT query
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <egorst@xxxxxxxxx>, <Ogun.Heper@xxxxxxxxxxxxxxx>
- Date: Wed, 28 Jun 2006 11:16:07 -0400
Hmm, but dep=0. If they were recursive calls, dep would be >0, correct?
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
Ours is the age that is proud of machines that can think and suspicious
of men who try to. --H. Mumford Jones, 1892-1980
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Egor Starostin
Sent: Wednesday, June 28, 2006 4:01 AM
To: Ogun.Heper@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Long execute phase for SELECT query
> Are you sure that this EXEC line belongs to your cursor? It shows 41
physical reads (p=41) and 804 consistent gets (cr=804) which are not
shown in the execute phase of the TKPROF output.
It means that they came from recursive calls.
--
Egor
http://www.oracledba.ru
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
