Re: wait events not as v$sql_plan

Thanks KG. I concluded it from the plan. The Output is from V$sql_Plan.

It is quite funny that it says a Unuique Scan and Goes for a DB File Scattered Read on those Tables. I deduced the Tables from the p1 and p2 columns.

And those files (p1) have only the tables that are being unique scanned.

Any ideas ???

Thanks

Rgds
Ganesh

On Wed, 23 Mar 2005 00:14:46 +0530, K Gopalakrishnan <kaygopal_at_gmail.com> wrote:
> 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