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