| << Back to previous view |
|
[QA-25] ORA-00600 [kkslgop1] in SELECT when CURSOR_SHARING IS NOT EXACT. Created: 15/Jul/07 Updated: 16/Sep/07 |
|
| Status: | Closed |
| Project: | Questions & Answers |
| Fix Version/s: | None |
| Type: | Oracle - Internals | Priority: | Major |
| Reporter: | ubTools Support | Assignee: | ubTools Support |
| Resolution: | Answered | Votes: | 0 |
| Product Version: | 8.1.7.2.0 |
| Operating System: | IBM-AIX |
| Description |
|
ORA-00600 [kkslgop1] in SELECT when CURSOR_SHARING IS NOT EXACT.
|
| Comments |
| Comment by 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:
|