oracle troubleshooting

[pande.dhiraj]

i have find that problem so anybody can tell me, why this problem has been raised. and what is the way to troubleshoot this error.

ORA-04031: unable to allocate 3904 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kglsim object batch")

thanks in advance.

regards

[susarlasireesha]

Either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value set for the SHARED_POOL_SIZE initialization parameter.