Re: Guidelines for avoid Bind Variable Peeking behavior

We had a very similar situation running 10.2.0.3 on HP-UX with ASMM 
enabled.  It turned out our SGA was overly sized, and in this case, when 
the SGA was lowered, the problem went away.  We were surmising that since 
Oracle thought it had a lot of room to work in, it didn't attempt to 
optimize.  We worked on this for a few weeks, opened an iTar, and got 
nowhere.  When we lowered the SGA to start tuning from the beginning 
again, it went away.  This was the only change made.

------------------------------------------------------------------------
Sherrie Kubis
Oracle DBA Supervisor
Information Resources Department
Application Systems Section 
Southwest Florida Water Management District
352-796-7211 x4033
mailto:Sherrie.Kubis@xxxxxxxxxxxxxxxx
http://www.watermatters.org
-------------------------------------------------------------------------
 =' т '=
Better train people and risk they leave - than do nothing and risk they 
stay.



IMPORTANT NOTICE:  All E-mail sent to or from this address are public record 
and archived.  The Southwest Florida Water Management District does not allow 
use of District equipment and E-mail facilities for non-District business 
purposes.

Other related posts: