Oracle Database Discussions

Hello,

I am having 11.1.0.7 on AIX and using Automatic Memory Management.

Following Parameters have been set -

memory_max_target = 10G
memory_target = 10G
sga_max_size = 10G
db_keep_cache_size = 2G

I have following two questions -

1. When I look at the Memory Advisor, it doesn't show me that increasing memory will help but i can see same process is now taking a long time to run and CPU is not a constraint. This leads me to think if there is any other way to see if my database is memory bound other than Memory Advisor.

2. When I started the database Oracle gave 40% to PGA and 60% to SGA. In our case, PGA - 4G and SGA - 6G. But I found that even though PGA is currently using only 500M, SGA is still having only the 60% (i.e., 6G) to play with and not the 9.5G.

As per the document, Oracle should automatically allocate/tune the SGA and PGA as per the requirement but looks like it's not happening.

Am I missing something here or should I specifically set the pga_aggregate_target to, lets say 500M.

What experience you guys have with AMM.

Thanks!