memory issue question and setup prob

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:

Code:

---

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

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

no it is on windows 2008 R2

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.

Code:

---

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;

---