Re: problems with memory
- From: Remigiusz Sokolowski <rems@xxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 11 May 2007 10:15:49 +0200
Dennis Williams wrote:
Remigiusz,
A cruder method which might reduce the incident of these errors would
be to increase the SGA, assuming you can allocate more memory.
Dennis Williams
Not exactly, I guess. If it is automatic management, this does not mean
one is secure - increasing SGA_TARGET does not mean that in particular
moment there is enough memory in let's say shared pool.
The way is to increase minimal setting for SHARED_POOL_SIZE and yes,
that could help (and that could be done without increasing SGA_TARGET).
Anyway we just turn it off.
--
---------------------------------------------------------------------
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:
