Increase SGA? ORA-04031

[ralexsander]

Environment information:
* Oracle version: 10.2.0.1.0
* Operating system: Windows 2003 64 bits in English
* Error: ORA-04031: Unable to Allocate 3608 Bytes of shared Memory

I do not have much knowledge in Oracle,

2 weeks that I am facing this problem, from time to time this error appears:

Select all

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

I saw in some places that it is necessary to increase the memory in some parameters, I was able to increase the SHARED_POOL_SIZE and the LARGE_POOL_SIZE I can not increase anymore.

My SGA_MAX_SIZE is only 304MB and my server that only Oracle wheel has 4GB of physical memory. How do I increase SGA_MAX_SIZE

does anyone have any tips?

Att.
Ricardo

[gilbertoca]

I recommend reading this [url=http://en.glufke.net/oracle/viewtopic.php?t=2059#6362]tópico

Gilberto

[diegoleite]

In SGA manual management mode.

Select all

ALTER SYSTEM SET db_cache_size = NNNm SCOPE=BOTH; 
ALTER SYSTEM SET java_pool_size = NNm SCOPE=BOTH; 
ALTER SYSTEM SET large_pool_size = NNm SCOPE=BOTH; 
ALTER SYSTEM SET shared_pool_size = NNNm SCOPE=BOTH; 
ALTER SYSTEM SET sga_target = 0m SCOPE=BOTH;--SGA MANUAL 
ALTER SYSTEM SET sga_max_size = NNNm SCOPE=SPFILE;

You will have Shutdown instance and Start again.