Re: wait events not as v$sql_plan

  • From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
  • To: ganesh.raja@xxxxxxxxx
  • Date: Wed, 23 Mar 2005 00:14:46 +0530


Is this plan from V$SQL_PLAN or EXPLAIN_PLAN? I have got the message
scrambled, so I couldn't visualize the plan. But I see there is a
range scan, and that could have caused the scattered reads?

How did you conclude the FTS on that tables? Based on the scattered
read or from the plan?

Best Regards,
K Gopalakrishnan 
Co-Author: Oracle Wait Interface, Oracle Press 2004

Other related posts: