RE: Long execute phase for SELECT query

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Egor Starostin
Sent: Wednesday, June 28, 2006 4:01 AM
To: Ogun.Heper_at_turkcell.com.tr
Cc: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l