Error message when software is at its peak
ORA-04031: unable to allocate %s bytes of shared memory
I found out this error is possibility due to the number of sessions that has been created. I don't understand why this is happening. I'm checking the codes of the software to see if there is unnecessary connections opened and to see if there are many record sets opened that may cause a session(possible at times). Please note: once one user, say who has a lot of sessions created on using the software over a period of time, closes his application the sessions get killed. Please tell me as to why these sessions get created. Is it because of improper coding, or if the Oracle tuning has to be looked into? At present, the number of processes is 1,900 and the sessions are 2,095 in the running and spfile.
Additionally, there is a bug in early versions of Oracle 9i that caused the Shared Pool to mismanage its memory usage, resulting in this error. To fix this bug, you will have to apply the Oracle 9.2.0.6 patchset.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments