Q
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close