memory issue question and setup prob

[midora]

Hello I am trying to navigate the problem i am having with memory issues and

ORA-04031: unable to allocate 32 bytes of shared memory

my memory set up this way by previous dba:

memory_target      = 0
Mameroy_Max_target = 6442450944	
large_pool_size	   = 0	
sga_max_size	   = 6442450944	
sga_target	   = 3170893824	
shared_pool_size   = 0

on oracle 11.2.03

Please guide what should be and need done.

Thanks

[gandolf989]

If this is Linux or Unix what do you get when you run "df -h /dev/shm" at the command line?

[midora]

no it is on windows 2008 R2

[gandolf989]

If you want to use AMM The you only need to set memory_max_target and memory_target.
The total of your pga_aggregate_limit and sga_max_size can not exceed memory_max_target.
You should be able to specify the parameters as I have them and the database will manage
the memory for you.

alter system set memory_max_target       = 6G    scope=spfile;
alter system set memory_target           = 6G    scope=spfile;

alter system set pga_aggregate_limit     = 2G    scope=spfile;
alter system set pga_aggregate_target    = 2G    scope=spfile;
alter system set sga_max_size            = 4G    scope=spfile;
alter system set sga_target              = 4G    scope=spfile;