Problem solve
Get help with specific problems with your technologies, process and projects.
Why am I receiving Oracle memory allocation errors?
Are you receiving Oracle memory allocation errors? Learn why you may be having memory allocation problems in Oracle in this tip from Oracle expert Brian Peasland.
I am facing issues with Oracle memory allocation with an Oracle 9.2.0.5 instance on Windows Server 2003 Standard Edition with 4 GB physical memory. The processes run out of memory, sometimes the instance does not allow any new connections (ORA-12500: TNS:listener failed to start a dedicated server process) and the response for existing sessions is very slow. I don't get an error on alert log but RMAN gives the following error: RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on oem_backup_disk1 channel at 10/08/2009 22:00:29 ORA-04030: out of process memory when trying to allocate 524812 bytes (pga heap, KSFQ Buffers) Can you give me any suggestions to solve the problem?
If both the PGA and SGA size exceeds 4GB on Windows, you will need to enable AWE for the OS. To do so, you need to add the "/3GB" and "/PAE" switches in your boot.ini file and reboot the server.
This was last published in November 2009
Dig Deeper on Oracle database design and architecture
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