Re: Automatic Memory Management

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Tue, 8 Jan 2013 22:24:34 +0100
Message-ID: <CALH8A93WUkYyo3bkqJO3vxNd4p2FHaEEWYXbXFrUfnQkLVb4gg_at_mail.gmail.com>



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
Received on Tue Jan 08 2013 - 22:24:34 CET

Original text of this message