Re: problems with memory

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) 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: