ORA-04031

[alagy]

I'm getting the following error in my instance

ORA-04031 : Unable to allocate 8192 bytes of
shared memory (large pool)


What exactly to be done to fix this error?
Is is enough if I just increase the value
of shared_pool_size and shared_pool_reserved_size?

What to be done?

Could someone guide me..?

[oravijay]

Hi,

Increase the value of SHARED_POOL_SIZE, SHARED_POOL_RESERVED_SIZE.
If the large pool is out of memory then increase LARGE_POOL_SIZE.

Also, if u have large packages try to pin large packages using DBMS_SHARED_POOL
for reducing your use of shared memory.

Vijay.

[julian]

Originally posted by alagy
I'm getting the following error in my instance

ORA-04031 : Unable to allocate 8192 bytes of
shared memory (large pool)


What exactly to be done to fix this error?
Is is enough if I just increase the value
of shared_pool_size and shared_pool_reserved_size?

What to be done?

Could someone guide me..?

Your shared pool is probably fragmented, this happens as time passes :-) I would increase shared_pool_size and try to pin some packages. If you use Oracle 7.3.4 or above try to set shared_pool_reserved_size to about 10% of shared_pool_size. I usually set it to 10-20% depending on the application.