Automatic Memory Management

From: Juan Miranda <>
Date: Tue, 8 Jan 2013 15:40:38 +0100
Message-ID: <010c01cdedae$205f47a0$611dd6e0$>


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.  


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?

-- Received on Tue Jan 08 2013 - 15:40:38 CET

Original text of this message