-
Oracle shared memory error
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
-
Hi,
Increase shared_pool_size and shared_pool_reserved_size in init.ora.
bye
gandhi
-
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.
K.Chithra
Oracle DBA
-
Chithra,
Code:
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|