Oracle.exe consuming 100% CPU on windows and database hang
741376Mar 11 2010 — edited Mar 11 2010Hi all,
every time my oracle database is hanging when the application run, the problem is the oracle.exe consum 100% CPU but not memory and the server hang and the dabase is going to inaccessible, we need to restart oracle instance service or server to bring the databas eback to normal but it's not permanent because the problem occurs once the application turn on.
Checking the log file i found the below error every time:
My database version is 9.2.0.7.0
OS: Windows 2003 Server Standard Edition Service Pack 2
RAM: 3,5Gb
CPU: Inte Xeon 3.20 GHz
ORA-00600: internal error code, arguments: [kghuclientasp_03], [0xBFEADCE0], [0], [0], [0], [], [], []
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04050: error while attempting to allocate 163500 bytes of memory
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
Fri Mar 05 05:35:15 2010
Errors in file e:\oracle\admin\optprod\udump\optprod_ora_5876.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8180 bytes (callheap,kcbtmal allocation)
Thank you
Lucienot.