OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » RCA Report (windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RCA Report [message #538856]

Tue, 10 January 2012 00:15

sandeip
Messages: 23
Registered: May 2011
Location: pune

Junior Member

Hi,

we have OS detail: Microsoft Windows Server 2003
Standard Edition
Service Pack 2

We have upgraded our database from 9.2.0.8.0 to 11.2.0.1.0
From past 5 months database working fine but on day before yesterday we got error in alert log as

Errors in file f:\app\diag\rdbms\trac\trac\trace\trac_ora_3732.trc (incident=41729):
ORA-04030: out of process memory when trying to allocate 524812 bytes (kxs-heap-w,kllcqgf:kllsltba)

Process startup failed, error stack:
Errors in file f:\app\diag\rdbms\trac\trac\trace\trac_psp0_5120.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
Incident details in: f:\app\diag\rdbms\trac\trac\incident\incdir_41737\trac_ora_5900_i41737.trc

Sat Jan 07 18:40:46 2012
Trace dumping is performing id=[cdmp_20120107184045]
Errors in file f:\app\diag\rdbms\trac\trac\incident\incdir_41729\trac_ora_3732_i41729.trc:
ORA-04030: out of process memory when trying to allocate 824492 bytes (pga heap,kco buffer)
ORA-04030: out of process memory when trying to allocate 524812 bytes (kxs-heap-w,kllcqgf:kllsltba)
Errors in file f:\app\diag\rdbms\trac\trac\trace\trac_ora_828.trc (incident=41747):
ORA-04030: out of process memory when trying to allocate 524812 bytes (kxs-heap-w,kllcqgf:kllsltba)

Sat Jan 07 18:44:03 2012
Sweep [inc][41857]: completed

we have increases/decrease the process and sessions and parameter,but it doesn't work.

Soon after we have change our parameter file then issue gets resolve.

Right now i have to submit the RCA(Root Cause Analysis) report for the same.

Please help me in explaining the root cause of the issue and in submitting the same report.