problems with memory
- From: Remigiusz Sokolowski <rems@xxxxxxxx>
- To: 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 09 May 2007 15:38:32 +0200
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.024 zlotych (w calosci wplacony)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
