Re: problems with memory
- From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
- To: rems@xxxxxxxx
- Date: Wed, 9 May 2007 09:08:13 -0500
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@xxxxxxxx> 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@xxxxxxxx>
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)
--
//www.freelists.org/webpage/oracle-l
--
Charles Schultz
Other related posts:
