[#QA-25] ORA-00600 [kkslgop1] in SELECT when CURSOR_SHARING IS NOT EXACT.

Questions & Answers

ORA-00600 [kkslgop1] in SELECT when CURSOR_SHARING IS NOT EXACT.

Created: 15/Jul/07 05:39 PM Updated: 16/Sep/07 04:26 PM

Fix Version/s:

None

Product Version:	8.1.7.2.0
Operating System:	IBM-AIX

Description

« Hide

ORA-00600 [kkslgop1] in SELECT when CURSOR_SHARING IS NOT EXACT.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

ubTools Support - 15/Jul/07 05:42 PM

Error code:

ORA-00600: internal error code, arguments: [kkslgop1], [], [], [], [], [], [], []

Current SQL statement for this session:

SELECT COMP_TIME FROM CSTMAPSTATUS  WHERE CSTID = :"SYS_B_0" AND  SLOTNO = :"SYS_B_1"

Oracle kernel function from which the problem is raised:

kkslgop().

This is a function of Oracle Compilation Layer.

Process state:

PROCESS STATE
-------------
...
   ----------------------------------------
   SO: 404c6264, type: 3, owner: 403cde98, pt: 0, flag: INIT/-/-/0x00
   (session) trans: 40e83928, creator: 403cde98, flag: (8000041) USR/- BSY/-/-/-/-/-
             DID: 0001-0014-00000002, short-term DID: 0000-0000-00000000
             txn branch: 40f8201c
             oct: 3, prv: 0, user: 24/APPMGR
   O/S info: user: Administrator, term: CIMMB, ospid: 219:228, machine: PDP1_MES_DOM\CIMMB
             program: TIME_GAP.exe
   last wait for 'SQL*Net message from dblink' blocking sess=0x0 seq=60687 wait_time=-1
               driver id=54435000, #bytes=1, =0
     ----------------------------------------
...

Problem explanation:

As you see in your SQL statement, your bind variables are system generated bind variables. In other words, cursor sharing is enabled in your database.

Also, as seen in the process state, your last wait event is SQL*Net message from dblink. That means a dblink operation had been done before.

Workaround:

Use cursor_sharing=exact

Bug:

Bug:2169897 ORA-600 ARGUMENTS: [KKSLGOP1] VIA SELECT ACROSS DB_LINK

Bug:2159152 CURSOR_SHARING=FORCE MAY NOT SHARE STATEMENTS USING VIEWS IN 8172/8173
Back to top

Change by ubTools Support - 15/Jul/07 05:42 PM
Field	Original Value	New Value
Status	Open [ 1 ]	Closed [ 6 ]
Resolution		Answered [ 10 ]

Change by ubTools Admin - 16/Sep/07 04:09 PM
Resolution	Answered [ 10 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Change by ubTools Admin - 16/Sep/07 04:09 PM
Issue Type	Problem [ 1 ]	Oracle - Internals [ 8 ]

Change by ubTools Admin - 16/Sep/07 04:10 PM
Status	Reopened [ 4 ]	Closed [ 6 ]
Resolution		Answered [ 10 ]

Change by ubTools Admin - 16/Sep/07 04:16 PM
Resolution	Answered [ 10 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Change by ubTools Support - 16/Sep/07 04:26 PM
Status	Reopened [ 4 ]	Closed [ 6 ]
Resolution		Answered [ 10 ]