Wolfgang Breitling wrote:
>Do you have histograms on any predicate columns that use bind variables?
>Depending on the actual bind value at the time of the parse you can easily
>get different plans. The scenario could be that over night the sql with the
>plan ages out of the shared pool and the next morning it gets re-parsed by
>the first person to use that sql. Then, because of the BV and cursor
>sharing, the plan gets locked-in until the sql ages out again.
>
>At 03:39 AM 5/20/2005, Terry Barnett wrote:
>
>
>
Wolfgang, can you comment a bit on Christian's statement about memory
allocation influencing SQL
execution plan?
--
Mladen Gogala
Oracle DBA
Ext. 121
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 20 2005 - 12:45:02 CDT
