Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04030: out of process memory when trying to allocate + ORA-27300

806487Nov 30 2010 — edited Nov 30 2010
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2010
Added on Nov 30 2010
8 comments
2,852 views