Re: FYI - 10gR2 automatic memory management bugs

• "Schultz, Charles" <sac_at_uillinois.edu> wrote:
  > In hopes that nobody else suffers critical slowdowns in their production
  > database in the middle of the day or night, I am sharing what we have
  > recently learned about some of the automatic memory management
  > "features" (aka, bugs).
  >
  > Apparently, the algorithms that decide when and how fast to grow the
  > shared pool are a bit less than ideal.
  > <...>
  > was told that 4466399 was only available in v11. And since there is an
  > ingenious work-around, no one-off patch is planned. What is this
  > work-around? Simple, turn off the automatic tuning features by setting
  > sga_target = 0.
  >
  

This is a perfect example of why it's best to hop from one terminal release to the next one. After staying on the bleeding edge and being used as a Guinea pig for a number of years I have become very conservative when it comes to production implementation of "hot" new technologies.

Regards,
- Vitaliy

--
http://www.freelists.org/webpage/oracle-l