Oracle shared memory error

[k007]

Hello all,

I am running oracle 817 on RH Linux 7.2 and running iPlanet webserver for applications. I keep getting the following errors around once a week or even at a greater frequency

ORA-04031: unable to allocate 2560 bytes of shared memory ("large poo
l","unknown object","session heap","First curdef allocation")

I have tried increasing the large pool size in the init.ora file, increased the max cursors as well but still the error persists. I also get thsi errors on RH 6.2 . I have tried increasing the shmmax parameter as well but to no success :(

Is there a way to determine how much size should be put for large pool and other parameters ? or is this related to any system patches for linux ? because on solaris everything works fine.. I tried to search on google but most of the results show increase in pool size which I have already tried ...

Any help is highly appreciated.

Thanks
K

[gandhi]

Hi,
Increase shared_pool_size and shared_pool_reserved_size in init.ora.


bye
gandhi

[k.chithra]

Hi,
Lots of parsing causes fragmentation on sharedpool which has to be avoided.If parsing is more,adding shared pool size, might worsen the situation as it has to scan more memory than before for similar SQL statements.

Frequently used packages could be KEPT in the shared pool using dbms_shared_pool.keep procedure.

For more information can check
Docid 62143.1 in Metalink.

[Thomasps]

Chithra,

ORA-04031: unable to allocate 2560 bytes of shared memory ("large poo
l","unknown object","session heap","First curdef allocation")

It is large pool.. not shared pool.

[k007]

Thanks everyone for the prompt responses

but as i had already mentioned in my mail, i hv tried increasing both shared_pool_size & large_pool_size but it did not help.. I have read on some of the pages that came up on a google search that there is some bug in the version 8.1.7.0.0 , is it so ? is so is anyone aware of some patch available for this ?

Thanks
K