Problem When Implementing AWE Database Running Out Of Memory Allocation
(Doc ID 452413.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.7 to 11.2.0.2 [Release 9.2 to 11.2]Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Microsoft Windows (32-bit)
Symptoms
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 <ORACLE_HOME>\udump\<SID>_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 <ORACLE_HOME>\udump\<SID>_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 <ORACLE_HOME>\udump\<SID>_j000_2372.trc:
ORA-00600: internal error code, arguments: [kgassg_2], [], [], [], [], [], [], []
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |