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
Ganesh:
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
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: wait events not as v$sql_plan
- From: Ganesh Raja
- References:
- wait events not as v$sql_plan
- From: Ganesh Raja
Other related posts:
- » wait events not as v$sql_plan
- » RE: wait events not as v$sql_plan
- » Re: wait events not as v$sql_plan
- » Re: wait events not as v$sql_plan
- Re: wait events not as v$sql_plan
- From: Ganesh Raja
- wait events not as v$sql_plan
- From: Ganesh Raja