Re: problems with memory

My advice, based on practical experience, TURN IT OFF! (it = ASMM) I can dig up some metalink notes if you like. If I recall, I even posted a few notes here on the oracle-l list, and folks followed-up with their own thoughts. But save yourself the trouble and just turn it off.

On 5/9/07, Remigiusz Sokolowski <rems_at_wp-sa.pl> wrote:
>
> Hi!
>
> from time to time one of our production servers experience ORA-04031
> (lack of memory in SGA).
> today it happens to PMON, so the instance went down.
>
> The software is 10gR2 with enabled ASMM.
> We suppose ASMM is responsible for such behaviour (from our point of
> view the instance and the system it runs on has enough memory in
> disposition) - in our opinion it would do better on instances with less
> turbulent workload (it is OLTP connected with some internet apps).
>
> I would like to hear from You if You have similar/opposite experience
> with this feature.
>
> Best regards
> Remigiusz
>
> --
> ---------------------------------------------------------------------
> Remigiusz Sokolowski <rems_at_wp-sa.pl>
> WP/PTI/DIP/ZAB (+04858) 52 15 770
> MySQL v04.x,05.x; Oracle v10.x
>
> Zastrzezenie:
> Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora
> i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa
> Wirtualna Polska S.A.
> ---------------------------------------------------------------------
>
>
>
> WIRTUALNA POLSKA SA, ul. Traugutta 115c, 80-226 Gdansk; NIP:
> 957-07-51-216;
> Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024zlotych (w calosci wplacony)
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Charles Schultz

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