If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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 ...

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.

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 ?