ORA-04030: out of process memory when trying to allocate + ORA-27300
806487Nov 30 2010 — edited Nov 30 2010Hi,
I am facing follwoing error in alert.log file in one of the database.
Errors in file e:\app\diag\rdbms\infraorc\infraorc\trace\infraorc_j000_6008.trc (incident=67012):
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)
Incident details in: e:\app\diag\rdbms\infraorc\infraorc\incident\incdir_67012\infraorc_j000_6008_i67012.trc
Tue Nov 30 12:45:16 2010
Errors in file e:\app\diag\rdbms\infraorc\infraorc\trace\infraorc_dia0_3744.trc (incident=69518):
ORA-04030: out of process memory when trying to allocate 620 bytes (ksdhng_work_he,ksdhng: nd wfg)
Errors in file e:\app\diag\rdbms\infraorc\infraorc\trace\infraorc_j000_6008.trc (incident=67013):
ORA-04030: out of process memory when trying to allocate ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)
bytes (,)
Tue Nov 30 12:45:17 2010
Trace dumping is performing id=[cdmp_20101130124517]
Tue Nov 30 12:45:20 2010
Sweep Incident[69518]: completed
Sweep Incident[67013]: completed
Sweep Incident[67012]: completed
Tue Nov 30 12:45:20 2010
Process startup failed, error stack:
Errors in file e:\app\diag\rdbms\infraorc\infraorc\trace\infraorc_psp0_1064.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: Not enough storage is available to process this command.
ORA-27302: failure occurred at: ssthrddcr
Tue Nov 30 12:45:21 2010
Process m001 died, see its trace file
Tue Nov 30 12:48:58 2010
Restarting dead background process DIA0
Tue Nov 30 12:48:58 2010
DIA0 started with pid=51, OS id=5212
following is the database credential :
OS Type: Windows 2003 Standerd Edition with service pack 1
Type of server: VIRTUAL SERVER
RAM SIZE: 2GB
Oracle database version is : 11.1.0.6
Database sga_size : 824M
in 11g there is one parameter that is memory_target : 1.3GB
Can anybody tell me why this problem come into the database?
and what is the solution for the same?
Thanks