HP-UX Itanium 10.2.0.2 & 10.2.0.3 Oracle Database

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

ISSUE CLARIFICATION
====================
ORA-00600 [kghsskins1] reporting in alert log frequently.

Fri Aug 1 03:00:07 2008
Errors in file /u01/app/oracle/admin/STSDI/udump/stsdi2_ora_13919.trc:
ORA-00600: internal error code, arguments: [kghsskins1], [], [], [], [], [], [], []

eos (end of section)
.
ISSUE VERIFICATION
===================
Verified the issue by the alert log file alert_STSDI2.log,reports
Fri Aug 1 03:00:07 2008
Errors in file /u01/app/oracle/admin/STSDI/udump/stsdi2_ora_13919.trc:
ORA-00600: internal error code, arguments: [kghsskins1], [], [], [], [], [], [], []

Verified the issue by the trace file stsdi2_ora_13919.trc,reports
ORA-00600: internal error code, arguments: [kghsskins1], [], [], [], [], [], [], []

eos (end of section)
.
DATA COLLECTED
=============
Alert Log
~~~~~~~~~
Fri Aug 1 03:00:07 2008
Errors in file /u01/app/oracle/admin/STSDI/udump/stsdi2_ora_13919.trc:
ORA-00600: internal error code, arguments: [kghsskins1], [], [], [], [], [], [], []

Trace File
~~~~~~~~~~
Dump file /u01/app/oracle/admin/STSDI/udump/stsdi2_ora_13919.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name: HP-UX
Node name: g3u0970c
Release: B.11.23
Version: U
Machine: ia64
Instance name: STSDI2

Error
-----
ORA-00600: internal error code, arguments: [kghsskins1], [], [], [], [], [], [], []

Current SQL
-----------
SELECT v.cost_rule_id cost_rule_id FROM fm_cost_factor_vals v, tm_time_sheets ts WHERE v.cos
t_factor = 8 AND v.cost_factor_value = to_char(ts.resource_id) AND ( ts.
time_sheet_id IN (75397, 75400, 75426, 75428, 75429, 75430, 75435, 75445, 75447,
75452, 75459, 75460, 75461, 75462, 75477, 75479, 75503, 75505, 75510, 75535, 75
551, 75562, 75563, 75565, 75585, 75605, 75614, 75617, 75618, 75624, 75625, 75626
, 75629, 75636, 75645, 75647, 75648, 75649, 75653, 75655, 75669, 75701, 75703, 7
5713, 75722, 75725, 75732, 75737, 75738, 75743, 75763, 75767, 75787,

Call Stack
----------
ksedst ksedmp ksfdmp kgerinv kgeasnmierr
$cold_qcoplinext 480 kkqvacu kkqvcrf kkqvcerq
qksqbApplyToQbcLoc qksqbApplyToQbcLoc qksqbApplyToQbcLoc Cannot Cannot
qksqbApplyToQbc kkqdrv opiSem opiprs kksParseChildCursor
rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0
kksParseCursor opiosq0 kpooprx kpoal8 opiodr
ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real main main_opd_entry

Session info
------------
SO: c0000002401cd058, type: 4, owner: c0000002400057c8, flag: INIT/-/-/0x00
(session) sid: 540 trans: 0000000000000000, creator: c0000002400057c8, flag: (41) USR/- BSY/-/-/-/-/-
DID: 0002-0019-000026DC, short-term DID: 0002-0019-000026DD
txn branch: 0000000000000000
oct: 3, prv: 0, sql: c00000029d8e9b20, psql: c0000002a248b948, user: 138/PRODITG
O/S info: user: , term: , ospid: 1234, machine: G4W0812G
program:
last wait for 'library cache lock' blocking sess=0x0000000000000000 seq=7285 wait_time=454 seconds since wait started=8
handle address=c000000296a9b9a0, lock address=c00000029b9bf9e8, 100
*mode+namespace=12d
Dumping Session Wait History
for 'library cache lock' count=1 wait_time=454

Current cursor
-------------------
Cursor#1(9fffffffbf3c1710) state=SYNTAX curiob=9fffffffbf3efcf8
curflg=44 fl2=400 par=0000000000000000 ses=c0000002401cd058
sqltxt(c00000029d8e9b20)=
SELECT v.cost_rule_id cost_rule_id FROM fm_cost_factor_vals v, tm_time_sheets ts WHERE v.cost_factor =
8 AND v.cost_factor_value = to_char(ts.resource_id) AND ( ts.time_sheet
_id IN (75397, 75400, 75426, 75428, 75429, 75430, 75435, 75445, 75447, 75452, 75
459, 75460, 75461, 75462, 75477, 75479, 75503, 75505, 75510, 75535, 75551, 75562
, 75563, 75565, 75585, 75605, 75614, 75617, 75618, 75624, 75625, 75626, 75629, 7
5636, 75645, 75647, 75648, 75649, 75653, 75655, 75669, 75701, 75703, 75713, 7572
2, 75725, 75732, 75737, 75738, 75743, 75763, 75767, 75787,

eos (end of section)

47884

.
RESEARCH
=========
(Note: This is INTERNAL ONLY research. No action should be taken by the
customer on this information.
This is research only, and may NOT be applicable to your specific situation.)

Note 603689.1 (Internal) -> Ora-00600[Kghsskins1] for query with long in-list more than 32729 values

Bug 6439000
Abstract: ORA-600 [KGHSSKINS1] RUNNING QUERY WITH IN AND UNION CLAUSE
Status: 11,Code Bug (Response/Resolution)

Bug 7005209
Abstract: ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KGHSSKINS1],
Fixed In Ver: 11.2

eos (end of section)

.
ACTION PLAN
=========

I have reviewed the trace file contains and the issue is matching with the scenatio mentioned in the Bug 6439000.
Bug mentioned that, if the INLIST has more than 32729 values, then this error may come. I hav
e checked the trace files and finds that 47884 values are used in your select qu
ery. As the error is consistent kindly try the following and let me know the res
ult.

Rewrite the query so that the in-list is shorter than 32729 values
or try workaround by try

alter session set "_optimizer_join_elimination_enabled"=false;
alter system flush shared_pool;
then run problem query within the same session.

or set "_optimizer_join_elimination_enabled"=false within init.ora or spfile globally then restart database