I am facing issues with Oracle memory allocation with an Oracle 126.96.36.199 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.
Dig Deeper on Oracle database design and architecture
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.