Re: Long execute phase for SELECT query

  • From: "Egor Starostin" <egorst@xxxxxxxxx>
  • To: Ogun.Heper@xxxxxxxxxxxxxxx
  • Date: Wed, 28 Jun 2006 12:00:40 +0400

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


Other related posts: