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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

[ktbdchk] -- ktbgcl4 -- bad dscn - Oracle session taking up 99% CPU

Mike AlbertoneJun 19 2007 — edited Jun 19 2007
Hi !

This morning I found an Oracle session consuming up to 99% of a CPU (HP-UX 11.23 Oracle 10.2.0.1.0 running on HP IA).

Looking at the alert log I got:

Errors in file /opt/oracle/admin/NSMS/udump/nsms_ora_24148.trc:
ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], []
Tue Jun 19 05:27:58 2007

and into the referenced file:


[ktbdchk] -- ktbgcl4 -- bad dscn
scn: 0x0051.00a5c434scn: 0x0000.00a688d5
*** 2007-06-19 05:27:47.232
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], []
Current SQL statement for this session:
INSERT INTO SVCOBJ (SVCNAME,SOTNAME,SONAME,SOKEY,OWNERNAME,SYNCSTATUS,SOID,SOGID,ACCGRPNAME,SOGRPN
AME,SOTPURPOSE,PARENTSONAME,PARENTSOID,DESCENDACCESSPERM) VALUES (:SVCNAME,:SOTNAME,:SONAME,:SOKEY,:
OWNERNAME,:SYNCSTATUS,:SOID,:SOGID,:ACCGRPNAME,:SOGRPNAME,:SOTPURPOSE,:PARENTSONAME,:PARENTSOID,:DES
CENDACCESSPERM)

This happened during an insert into this table, but many other attempts were successful so that I don't think it's related to the table or to the data (but I'll check it further).

I've never seen the [ktbdchk] -- ktbgcl4 -- bad dscn error so that maybe you can point me to the right direction.

Thanks !

Mike

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2007
Added on Jun 19 2007
#general-database-discussions
4 comments
2,324 views