Gopalakrishna
Thankyou for info. Yeah you are right I find there was open cursors involved
in dead lock..Thank for info again.
>From: K Gopalakrishnan <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: arguments in ora-600
>Date: Mon, 11 Jun 2001 08:00:42 -0800
>
>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).
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raghu Kota
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).
