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/ -- //www.freelists.org/webpage/oracle-l