Re: wait events not as v$sql

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Wed, 23 Mar 2005 00:14:46 +0530
Message-ID: <3b0f44a105032210443f5d5cbc@mail.gmail.com>

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

Received on Tue Mar 22 2005 - 13:48:32 CST

Re: wait events not as v$sql_plan