Skip to Content
0
Former Member
Mar 22, 2010 at 07:19 AM

Share Memory issue : ORA-04031: unable to allocate 3936 bytes

277 Views

Hello Colleagues,

Please help me to fix the share memory frequency error occurance in my development system.

When ever we try to do the client copy the share memory problem is occuring

Database error text........: "ORA-04031: unable to allocate 3936 bytes of

shared memory ("shared pool","SELECT "TABNAME" , "DEVCLASS...","sga

heap(1,0)","kglsim object batch")"

Please find the current system config & memory size mentioned in the initsap.ora file and spfile

System Configuration

Intel(R) Xeon CPU

E5520 @2.27Ghz

6GB Ram

Paging file Size : 20400 MB

*.sga_max_size 10612736

*.sga_target 98907648

*.shared_pool_reserved_sizeH239738

*.shared_pool_sizeR8482304

*.db_block_size92

*.db_cache_sizeR8482304

SPFILE

*.sga_max_size 10612736

*.sga_target 98907648

*.shared_pool_reserved_sizeH239738

*.shared_pool_sizeR8482304

OS : Windows 2003 R2, Oracle 10g

Please any one guide us for tunning SGA and where changes need to be done

Best Regards,

Jai