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