Raghu !
Normally ORA-600s are bugs or because of some
unhandled expectations. The arguements are split up
between various kernel layers.
This note will help you in understanding the layers
and your 17302 falls under KGL (library cache
component). So this is probably a bug or something
related to settings in library cache parameter. (like
cursor_sharing, cursor_space_for_time like ).
So just check with OWS for any known bugs for your
release..
This is not the complete list and I have truncated
partly (because of the 4k message limit).
** 0000 ** Service Layer
========================
KIESCBAS (1)
Component notifier component
KIESDBAS (100)
Debug component
KIESEBAS (300)
Error component
KIESLBAS (500)
Lock component
KIESMBAS (700)
Memory component
KIESPBAS (900)
System Parameters component
KIESSBAS (1100) System
State object component
KIESGBAS (1110) Generic Linked
List management component
KIESQBAS (1150)
Enqueue component
KIESIBAS (1190)
Instance Locks component
KIESUBAS (1200) User
State object component
KIESABAS (1400)
Async Msgs component
KIESKBAS (1700)
license Key component
** 2000 ** Cache Layer Component Base internal error
values
===========================================================
KIECOBAS (2000)
Cache Op component
KIECCBAS (2100)
Control File mgmt component
KIECMBAS (2200)
Misc (SCN etc.)
KIECHBAS (2400)
Buffer Instance Hash Table
KIECRBAS (2600)
Redo file component
KIECFBAS (2800)
Db file component
KIECABAS (3000) Redo
Application component
KIECBBAS (3200)
Buffer manager base
KIECZBAS (3400) Archival & media
recovery component base
KIECLBAS (3500) direct
Loader component base
KIECVBAS (3600)
recoVery component base
KIECKBAS (3700)
Thread component base
KIECKBAS (3800) Compatibility
segment component base
** 4000 ** Transaction Layer
============================
Transaction Layer Component Base internal error
values:
KIETUBAS 4000
Transaction Undo Component
internal errors 4100-4199 used by transaction
undo component as well
KIETSBAS 4300
Transaction Segment
KIETCBAS 4400
Transaction Control Component
internal errors 4450-4499 used by transaction
distributed component
KIETBBAS 4500
Transaction Block Component
KIETABAS 4600
Transaction Table Component
KIETRBAS 4800
Query Row Cache Component
KIETMBAS 4900
Transaction Monitor Component
KIETSBAS 4950
Query Bootstrap Component
KIETEBAS 5000
Transaction Extent
** 6000 ** Data Layer
=====================
** 8000 ** Access Layer
=======================
Data Layer Component Base internal error values:
8000...8199 reserved for data layer
8100...8149 reserved for index component
8100 - 8109 used in KAU
8110 - 8124 used in KKRI, KDIC (create index)
** 10000 ** Control Layer
=========================
** 12000 ** User/Oracle Interface Layer
=======================================
User/Oracle Interface & SQL Layer "components" (in
a loose sense)
KIEUTBAS 12000 TAC*
component: 12000 .. 12009
KIEURBAS 12010 SORT
component: 12010 .. 12199
KIEUPBAS 12200 OPI*
component: 12200 .. 12299
KIEUSBAS 12300 PRS, APA, EVA, EXP, QBA
component: 12300 .. 12399
KIEUWBAS 12400 QKA, MSQ, and row source
components: 12400 .. 12499
KIEUVBAS 12600 *DRV
component: 12600 .. 12799
KIEUDBAS 12800 DIC and SDI
components: 12800 .. 12999
KIEUXBAS 13000 DELEXE,
UPDEXE, CRI: 13000 .. 13079
REF : 13080 .. 13089
WSM : 13090 .. 13099
KIEUABAS 13100
OPIAMR: 13100 ..13149
KIEULBAS 13200 ACL
and ATB : 13200 - 13230
KIEUZBAS 13250 AUD,
AUSDRV, AOP : 13250..13300
KIELCBAS 16000
loader column array builder
** 17000 ** Generic "Layer"
===========================
17000 - 17089 reserved for KGL;
17090 - 17099 reserved for KGE;
17100 - 17199 reserved for KGH;
17200 - 17249 reserved for KGLR/KGLRO;
17250 - 17269 reserved for KGP;
17270 - 17299 reserved for KGI;
17300 - 17399 reserved for KGHX;
17500 - 17989 reserved for other KG*;
17990 - 17999 reserved for PL/SQL;
=====
Have a nice day !!
------------------------------------------------------------
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
