How to solve ora-04030 error
I found ora-04030 ut of process memory when trying to allocate 16328 bytes error in alert log file. Below are the DB details....
Can anyone please tell me how to resolve this error, Do i need to increase open_cursors and session_cached_cursors here?
Thanks in Advance
ORA-04030 means your shared_pool is too fragmented.
As a workaround you can try to flush shared_pool but that's not a solution - just a bandaid.
You may want to incease shared_pool size - which will only delay the next occurence of the issue.
You may want to check for queries not using bind variables.
Check Metalink for details. Lots of information about ORA-04030 and no magic bullet; all depends on your system.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
This may be caused by one query/session, so identifying and tuning it may resolve it.
Click Here to Expand Forum to Full Width