Skip to Main Content
Forums

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-00600 - internal error in Oracle 10g Database

Su.giOct 12 2017 — edited Oct 12 2017

Hi All

I am using Oralce Database 10g 10.2.0.4 version.

I have have problem as below

The cause of this problem has been identified in
Bug 6795880 - BATCH JOBS HANG WAITING ON 'KKSFBC CHILD COMPLETION'

It is caused by a session going into an infinite spin just after a wait for 'kksfbc child completion'. The spin can be identified in the call stack by the following routines: kksSearchChildList -> kkshgnc, where kksSearchChildList loops forever.

This problem can also lead to internal errors such as:

ORA-600 [kksSearchChildList1]
ORA-600 [kksSearchChildList2]
ORA-600 [kksSearchChildList3]
ORA-600 [kkshgnc-nextchild]

pastedImage_0.png

Please help us to resolve this issue... Application is working fine, but new sessions are not created and throws the above issue.

Thanks in Advance,

Su.gi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2017
Added on Oct 12 2017
#general-database-discussions
5 comments
783 views