Re: Read by other session and db sequential read waits

From: Michael Elkin <>
Date: Sun, 19 Oct 2008 10:20:26 +0200
Message-ID: <>

Are you sure that no changes in execution plan occurred during the slowdown? You can easily verify this by querying AWR view :PLAN_HASH_VALUE.dba_hist_sql_plan

Of course you have to identify SQL_ID in advance.


On Fri, Oct 17, 2008 at 8:03 PM, Dennis Williams <> wrote:

> Younus
> Does your query use bind variables? I wonder if the first time this SQL is
> executed that query is submitted with an unusual value, which causes an
> execution plan that uses a FTS. Subsequent executions will continue to use
> that execution plan. Your flushing the shared pool causes that execution
> plan to be flushed so the next execution gets the execution plan that you
> desire.
> Dennis Williams

Best Regards
Michael Elkin

Received on Sun Oct 19 2008 - 03:20:26 CDT

Original text of this message