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_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.024 zlotych (w calosci wplacony)
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 11 2007 - 03:15:49 CDT
