Re: Long execute phase for SELECT query

  • From: "Egor Starostin" <egorst@xxxxxxxxx>
  • To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • Date: Wed, 28 Jun 2006 19:31:39 +0400

Hmm, but dep=0. If they were recursive calls, dep would be >0, correct? 
I'd say 'there were recursive calls'.
I.e. before first 'EXEC #9' there were several (or just one)
PARSE/EXEC/FETCH'es with non-zero p's, cr's and dep > 0.


--
Egor
http://www.oracledba.ru
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2006