Re: wait events not as v$sql_plan

From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
To: K Gopalakrishnan <kaygopal@xxxxxxxxx>
Date: Tue, 22 Mar 2005 21:58:10 +0000

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@xxxxxxxxx> 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

References:

wait events not as v$sql_plan
From: Ganesh Raja

Re: wait events not as v$sql_plan
From: K Gopalakrishnan

Re: wait events not as v$sql_plan

Other related posts: