Re: Automatic Memory Management

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: jcmiranda@xxxxxxxxx
  • Date: Tue, 8 Jan 2013 22:24:34 +0100

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@xxxxxxxxx>:

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: