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 220.127.116.11 patchset.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.