Problem When Implementing AWE Database Running Out Of Memory Allocation (Doc ID 452413.1)

Last updated on NOVEMBER 04, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.7 to 11.2.0.2 - Release: 9.2 to 11.2

Microsoft Windows (32-bit)

Symptoms

Checked for relevance on 4-Nov-2010

You have configured Windows to use AWE and are now receiving errors. You are getting ORA-4030 after implementing /AWE switch.

The errors are similar to:

Sat Jun 16 17:13:05 2007
Errors in file d:\oracle\admin\crplive\udump\crplive_j005_5380.trc:
ORA-12012: error on auto execute of job 3991889
ORA-04030: out of process memory when trying to allocate 2416 bytes (kolt heap ds i,koltalo-1)
ORA-04030: out of process memory when trying to allocate 2416 bytes (kolt heap ds i,koltalo-1)
ORA-04030: out of process memory when trying to allocate 2048 bytes (session heap,kocht)

Sat Jun 16 17:13:07 2007
Errors in file d:\oracle\admin\crplive\udump\crplive_j023_5872.trc:
ORA-12012: error on auto execute of job 1905842
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort subheap,sort key)
ORA-06512: at "PERFSTAT.STATSPACK", line 2743
ORA-06512: at line 1

Sat Jun 16 17:13:19 2007
Errors in file d:\oracle\admin\crplive\udump\crplive_j000_2372.trc:
ORA-00600: internal error code, arguments: [kgassg_2], [], [], [], [], [], [], []

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms