Re: Automatic Memory Management

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Wed, 9 Jan 2013 08:35:42 +0100
Message-ID: <50ED1DCE.3070008_at_nordea.com>

from time to time in certain situations even ASMM makes some troubles. So if You are more or less sure how much memory there should be in all the pools/caches then You may still set it manually - works very stable.

On 08.01.2013 22:24, Martin Berger wrote:

> Juan,
> You can set a value for DB_CACHE_SIZE which is used as a minimal setting.
> 
> By doing so you can allow AMM within some boundaries.
> 
> Hth,
> Martin
>  Am 08.01.2013 15:42 schrieb "Juan Miranda" <jcmiranda_at_oesia.com>:
> 

>>
>> I used to configure AMM assigning appropiate values to sga_target and
>> pga_aggregate_target
>>
>> but nearly all my dbs have more memory assigned to shared_pool than
>> buffer_cache.
>>
>>
>>
>> v$sgainfo;
>>
>>
>>
>> NAME BYTES RES
>>
>> -------------------------------- ---------- ---
>>
>> Buffer Cache Size 2751463424 Yes
>>
>> Shared Pool Size 3238002688 Yes
>>
>> Maximum SGA Size 6263357440 No
>>
>> Free SGA Memory Available 0
>>
>>
>>
>> I can´t solve the possible problems with bind variables, etc.
>>
>>
>>
>> What are you doing in this situation? manual MM?
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>

> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 

-- 
Pole na kazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : Senior DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A st, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, 
dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, 
VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, 
o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 09 2013 - 08:35:42 CET