问:在Windows Server 2003上有一个Oracle 9.2.0.5实例,其中物理内存为4GB。现在Oracle内存分配出现问题。进程运行时显示内存不足,有时实例不允许任何新的连接(ORA-12500: TNS:listener failed to start a dedicated server process),而且现有的会话反应也非常慢。RMAN现实的错误信息如下所示:
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)
请问该如何解决这一问题?
答:在Windows上,如果PGA和SGA的大小超过4GB,你需要为操作系统启动AWE。你可以在boot.ini文件上添加"/3GB" 和 "/PAE"switch,然后重启服务器即可。