Re: Read by other session and db sequential read waits
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: younus.siddiqui@xxxxxxx
- Date: Fri, 17 Oct 2008 13:03:37 -0500
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
Other related posts:
