ORA-04031 Error

[ManojMac]

Hi,

We are getting the ORA-04031 error while running our application on Database.

The exact error we get is:
Unable to allocate 4216 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","library cache")

As we found from the various sources, this is due to fragmented SGA, or insufficient Shared Memory.

Our init.ora Parameter for Shared Pool are:

shared_pool_reserved_size=52428800
shared_pool_size=524288000
java_pool_size=262144000

We are executing the SELECT query which return 8,00,000 rows. We are also having one other query which executed 8,00,000 times.

Is this SELECT Statement can cause this error?

As we are getting the Notification related to Library cache, is it related to fragmented Library Cache?

Please help us in resolving this issue.

Thanks in Advance.