Ora-00600 problem with oracle internal error 4454
420503Jan 15 2006 — edited Jan 15 2006Hi,
I am using oracle 8.1.7 version and calling a stored procedure from my application. I am sending 100 queries per second through my application to oracle. The testing was successful for almost 3 weeks now with that load and served 177511233 queries. But suddenly my application got restarted because of the oracle session crash.
Oracle session got crashed with the oracle error ora-00600 with 4454 as the first argument.
I am new to this and unable to understand what has caused this and what could be the solution to avoid this in future?
All I am doing is to query a database by calling a stored procedure from my application.
My application needs to run continuously.
Can any one suggest me what could be the reason?
I am pasting the trace file output justbefore the crash for your reference
----------------------------------------
Cursor 6 (140206ab0): CURBOUND curiob: 14021ebc8
curflg: cf curpar: 0 curusr: 12 curses 400a744b0
cursor name: SELECT PREFIX,MCODE FROM MATCHCDE WHERE RI = :b1
child pin: 0, child lock: 4027840d8, parent lock: 4027841b8
xscflg: 150424, parent handle: 4040f5e60, xscfl2: 5000000
bind 0: dty=2 mxl=22(21) mal=00 scl=00 pre=00 oacflg=03 oacfl2=1 size=24 offset
=0
No bind buffers allocated
End of cursor dump
ssexhd: crashing the process...
Shadow_Core_Dump = partial
--------------------------------------------------------------
Your help in this regard is highly appreciated.
Regards,
Shyam Hundi.