ORA-00600: internal error code
Hi,
i got following error in database and after that my database has started working very slow:
*"ORA-00600: internal error code, arguments: [kglsim_updnew2], [3], [], [], [], [], [], [] "*
following is the trce file generated when the error was logged:
my database is working properly but transactions takes lot of time than before.
SGA is 600 MB which is sufficient for my application to work.
Dump file e:\oracle\product\10.2.0\admin\oratms\udump\oratms_ora_5876.trc
Sat Sep 22 07:42:01 2012
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2685M/4084M, Ph+PgF:4845M/5953M, VA:1208M/2047M
Instance name: oratms
Redo thread mounted by this instance: 1
Oracle process number: 48
Windows thread id: 5876, image: ORACLE.EXE (SHAD)
**** 2012-09-22 07:42:01.343*
**** SERVICE NAME:(SYS$USERS) 2012-09-22 07:42:01.328*
**** SESSION ID:(122.12) 2012-09-22 07:42:01.328*
Shared Pool & Java Pool LRU Simulator State:
*============================================*
state=0x1 shared_pool=88080384 java_pool=4194304
pinv=16 lrbc=10240 lrbz=2 bktd=8192 lscn=8 robc=1024 rhpc=4096 mem=2 sfc=2
ldtm=403730886611 ldct=5972554 jldtm=0 jldct=0
pinsz=1930088 pinct=367 pintm=820319839 tltm=0
Pinned List [0] heap count sp=17, jp=0
*Total size sp= 52056 jp= 0 [no invalid 0]*
Transient: Pinned count 19, Expected 17
Total pinned memory on list [0] = 52056, in 17 heaps
Pinned List [1] heap count sp=26, jp=0
*Total size sp= 166200 jp= 0 [no invalid 0]*
Transient: Pinned count 29, Expected 26
Total pinned memory on list [1] = 166200, in 26 heaps
Pinned List [2] heap count sp=21, jp=0
*Total size sp= 82960 jp= 0 [no invalid 0]*
Transient: Pinned count 25, Expected 21
Total pinned memory on list [2] = 82960, in 21 heaps
Pinned List [3] heap count sp=20, jp=0
*Total size sp= 73000 jp= 0 [no invalid 0]*
Transient: Pinned count 25, Expected 20
Total pinned memory on list [3] = 73000, in 20 heaps
Pinned List [4] heap count sp=20, jp=0
*Total size sp= 83648 jp= 0 [no invalid 0]*
Transient: Pinned count 22, Expected 20
Total pinned memory on list [4] = 83648, in 20 heaps
Pinned List [5] heap count sp=20, jp=0
*Total size sp= 150416 jp= 0 [no invalid 0]*
Total pinned memory on list [5] = 150416, in 20 heaps
Pinned List [6] heap count sp=26, jp=0
*Total size sp= 290024 jp= 0 [no invalid 0]*
Transient: Pinned count 28, Expected 26
Total pinned memory on list [6] = 290024, in 26 heaps
Pinned List [7] heap count sp=29, jp=0
*Total size sp= 104432 jp= 0 [no invalid 0]*
Transient: Pinned count 34, Expected 29
Total pinned memory on list [7] = 104432, in 29 heaps
Pinned List [8] heap count sp=24, jp=0
*Total size sp= 83624 jp= 0 [no invalid 0]*
Transient: Pinned count 30, Expected 24
Total pinned memory on list [8] = 83624, in 24 heaps
Pinned List [9] heap count sp=14, jp=0
*Total size sp= 69064 jp= 0 [no invalid 0]*
Transient: Pinned count 20, Expected 14
Total pinned memory on list [9] = 69064, in 14 heaps
Pinned List [10] heap count sp=26, jp=0
*Total size sp= 102000 jp= 0 [no invalid 0]*
Transient: Pinned count 27, Expected 26
Total pinned memory on list [10] = 102000, in 26 heaps
Pinned List [11] heap count sp=22, jp=0
*Total size sp= 297616 jp= 0 [no invalid 0]*
Transient: Pinned count 26, Expected 22
Total pinned memory on list [11] = 297616, in 22 heaps
Pinned List [12] heap count sp=22, jp=0
*Total size sp= 79248 jp= 0 [no invalid 0]*
Transient: Pinned count 23, Expected 22
Total pinned memory on list [12] = 79248, in 22 heaps
Pinned List [13] heap count sp=29, jp=0
*Total size sp= 97960 jp= 0 [no invalid 0]*
Total pinned memory on list [13] = 97960, in 29 heaps
Pinned List [14] heap count sp=29, jp=0
*Total size sp= 126888 jp= 0 [no invalid 0]*
Transient: Pinned count 33, Expected 29
Total pinned memory on list [14] = 126888, in 29 heaps
Pinned List [15] heap count sp=23, jp=0
*Total size sp= 73024 jp= 0 [no invalid 0]*
Transient: Pinned count 27, Expected 23
Total pinned memory on list [15] = 73024, in 23 heaps
Pinned List [16] heap count sp=0, jp=0
*Total size sp= 0 jp= 0 [no invalid 0]*
Total pinned memory on list [16] = 0, in 0 heaps
Total memory on 17 pinned lists = 1932160
LRU List [1] bktcnt=14 rebalcnt=282
Bucket Summary (time in seconds)
*0: start= 0 size= 12582912 Ht=28654438 Tm=95323*
*Tot= 1156 sz= 12586648 ( 12586648) Ld= 21 Msz= 4240232[ 353]*
*1: start= 12582912 size= 12582912 Ht=1023930 Tm=1553*
*Tot= 1138 sz= 12602408 ( 12596128) Ld= 10 Msz= 156896[ 20]*
*2: start= 25165824 size= 12582912 Ht=471500 Tm=14143*
*Tot= 794 sz= 9680464 ( 9682536) Ld= 0 Msz= 283512[ 27]*
*3: start= 37748736 size= 12582912 Ht=238471 Tm=3724*
*Tot= 0 sz= 0 ( 0) Ld= 0 Msz= 0[ 0]*
*4: start= 50331648 size= 12582912 Ht=127870 Tm= 256*
*Tot= 1028 sz= 12597808 ( 12597808) Ld= 0 Msz= 39752[ 7]*
*5: start= 62914560 size= 12582912 Ht= 73904 Tm=1396*
*Tot= 908 sz= 12459096 ( 12459096) Ld= 1 Msz= 6280[ 1]*
*6: start= 75497472 size= 12582912 Ht= 43489 Tm= 101*
*Tot= 0 sz= 0 ( 0) Ld= 0 Msz= 0[ 0]*
*7: start= 88080384 size= 12582912 Ht= 28480 Tm= 70*
*Tot= 940 sz= 12590640 ( 12590640) Ld= 1 Msz= 14632[ 3]*
*8: start= 100663296 size= 12582912 Ht= 19445 Tm= 53*
*Tot= 1255 sz= 12551104 ( 12551104) Ld= 0 Msz= 6280[ 1]*
*9: start= 113246208 size= 12582912 Ht= 15630 Tm= 41*
*Tot= 0 sz= 0 ( 0) Ld= 0 Msz= 0[ 0]*
*10: start= 125829120 size= 12582912 Ht= 15206 Tm=11301*
*Tot= 1130 sz= 12601656 ( 12601656) Ld= 0 Msz= 0[ 0]*
*11: start= 138412032 size= 12582912 Ht= 12938 Tm=13695*
*Tot= 1110 sz= 12507008 ( 12507008) Ld= 0 Msz= 0[ 0]*
*12: start= 150994944 size= 12582912 Ht= 9074 Tm=13211*
*Tot= 0 sz= 0 ( 0) Ld= 0 Msz= 0[ 0]*
*13: start= 163577856 size= 12582912 Ht= 7425 Tm=7110*
*Tot= 6908 sz= 86433784 ( 86433784) Ld=17825 Msz= 3185096[ 162]*
LRU [1] Total heap cnt=16367 sz=196610616 SP.Pin=0 SP.Lru=576
SP.Free=9879 SP.Invl=5912
LRU List [9] bktcnt=2 rebalcnt=0
Bucket Summary (time in seconds)
*0: start= 0 size= 4194304 Ht= 0 Tm= 0*
*Tot= 0 sz= 0 ( 0) Ld= 0 Msz= 0[ 0]*
*1: start= 4194304 size= 4194304 Ht= 0 Tm= 0*
*Tot= 0 sz= 0 ( 0) Ld= 0 Msz= 0[ 0]*
LRU [9] Total heap cnt=0 sz=0 SP.Pin=0 SP.Lru=0
SP.Free=0 SP.Invl=0
HASH TABLE
*Total object cnt = 10639 [invl cnt=3487]*
*Free Sim Objects list [ 0] cnt = 298*
*Free Sim Objects list [ 1] cnt = 26*
*Free Sim Objects list [ 2] cnt = 228*
*Free Sim Objects list [ 3] cnt = 104*
*Free Sim Objects list [ 4] cnt = 279*
*Free Sim Objects list [ 5] cnt = 228*
*Free Sim Objects list [ 6] cnt = 129*
*Free Sim Objects list [ 7] cnt = 202*
*Free Sim Objects list [ 8] cnt = 150*
*Free Sim Objects list [ 9] cnt = 378*
Free Sim Objects list [10] cnt = 298
Free Sim Objects list [11] cnt = 271
Free Sim Objects list [12] cnt = 397
Free Sim Objects list [13] cnt = 317
Free Sim Objects list [14] cnt = 287
Free Sim Objects list [15] cnt = 259
Free Sim Objects list [16] cnt = 0
Free Sim Objects in Hash Table = 3487
*Free Sim Heaps list [ 0] cnt = 479*
*Free Sim Heaps list [ 1] cnt = 92*
*Free Sim Heaps list [ 2] cnt = 427*
*Free Sim Heaps list [ 3] cnt = 160*
*Free Sim Heaps list [ 4] cnt = 487*
*Free Sim Heaps list [ 5] cnt = 346*
*Free Sim Heaps list [ 6] cnt = 186*
*Free Sim Heaps list [ 7] cnt = 289*
*Free Sim Heaps list [ 8] cnt = 242*
*Free Sim Heaps list [ 9] cnt = 621*
Free Sim Heaps list [10] cnt = 457
Free Sim Heaps list [11] cnt = 381
Free Sim Heaps list [12] cnt = 648
Free Sim Heaps list [13] cnt = 462
Free Sim Heaps list [14] cnt = 475
Free Sim Heaps list [15] cnt = 464
Free Sim Heaps list [16] cnt = 0
Free Sim Heaps on Pin lists = 0, on LRU Lists = 5912
Total sim memory size after nfy = 2335120
**** 2012-09-22 07:42:01.390*
ksedmp: internal or fatal error
*ORA-00600: internal error code, arguments: [kglsim_updnew2], [3], [], [], [], [], [], []*
No current SQL statement being executed.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst+38 CALLrel ksedst1+0 0 1*
ksedmp+898 CALLrel ksedst+0 0*
ksfdmp+14 CALLrel ksedmp+0 3*
_kgerinv+140 CALLreg 00000000 A3BF440 3*
kgesinv+36 CALLrel kgerinv+0 A3BF440 BBF0020 607AF678 1*
BD9C6BC
kgesin+19 CALLrel kgesinv+0 A3BF440 BBF0020 607AF678 1*
BD9C6BC
*__VInfreq__kglsim_u CALLrel _kgesin+0 A3BF440 BBF0020 607AF678 1 0*
pd_newhp+194 3 0
kksLoadParent+768 CALLrel kglsim_upd_newhp+0 A3BF440 2FCD5CD0 4 244 7FFF 0*
*0 0 2F5C6038*
kkslod+187 CALLrel kksLoadParent+0 A3BF440 2FCD5C08 BD9CCC0*
_kglobld+912 CALLreg 00000000 A3BF440 2FCD5C08 BD9CCC0*
kglobpn+918 CALLrel kglobld+0 A3BF440 2F5C5FB4 BD9CCC0*
*3179D5F0 0*
kglpim+264 CALLrel kglobpn+0 A3BF440 3179D5F0 BD9CCC0 1*
kglpin+928 CALLrel kglpim+0 A3BF440 BD9CCC0 3179D5F0*
kkspsc0+1356 CALLrel kglpin+0 A3BF440 BD9CCC0 313536CC*
*2FCD5C08 3 3 BD9CD18*
kksParseCursor+143 CALLrel kkspsc0+0*
opiosq0+1965 CALLrel kksParseCursor+0 BD9CF38*
kpooprx+232 CALLrel opiosq0+0 3 E BD9D070 A4*
kpoal8+775 CALLrel kpooprx+0 BD9F690 BD9D6E8 243 1 0 A4*
_opiodr+1099 CALLreg 00000000 5E 17 BD9F68C*
_ttcpip+996 CALLreg 00000000 5E 17 BD9F68C 0*
_opitsk+1080 CALL??? 00000000*
opiino+1087 CALLrel opitsk+0 0 0*
_opiodr+1099 CALLreg 00000000 3C 4 BD9FC28*
opidrv+819 CALLrel opiodr+0 3C 4 BD9FC28 0*
sou2o+45 CALLrel opidrv+0 3C 4 BD9FC28*
opimaireal+112 CALLrel _sou2o+0 BD9FC1C 3C 4 BD9FC28*
opimai+92 CALLrel opimai_real+0 2 BD9FC54*
OracleThreadStart@ CALLrel opimai+0*
*4+726*
*77E64826 CALLreg 00000000*
--------------------- Binary Stack Dump ---------------------
*========== FRAME [1] (_ksedst+38 -> _ksedst1+0) ==========*
Dump of memory from 0x0BD9C56C to 0x0BD9C57C
*BD9C560 0BD9C57C [|...]*
*BD9C570 0040490B 00000000 00000001 [.I@.........]*
*========== FRAME [2] (_ksedmp+898 -> _ksedst+0) ==========*
Dump of memory from 0x0BD9C57C to 0x0BD9C63C
BD9C570 0BD9C63C [<...]
*BD9C580 00403303 00000000 31310000 00001000 [.3@.......11....]*
*BD9C590 0000000B 30400048 0BD9C5F4 603A8D2E [....H.@0......:`]*
*BD9C5A0 603A8D76 0A3BF8E0 0BD9C5BC 00000001 [v.:`..;.........]*
*BD9C5B0 34364925 04D70075 00000000 00000000 [%I64u...........]*
*BD9C5C0 00000000 00000000 00000000 00000000 [................]*
*BD9C5D0 34364900 34364925 34360075 00000001 [.I64%I64u.64....]*
*BD9C5E0 0A3BF544 0A3BF53C 607AF678 FFFFFFFF [D.;.<.;.x.z`....]*
*BD9C5F0 000007E7 0BD9C638 00000001 00000000 [....8...........]*
*BD9C600 00000000 00000000 00000001 00000000 [................]*
*BD9C610 00000000 0A3BF440 0BBF0020 032B15C0 [....@.;. .....+.]*
*BD9C620 00000001 0BD9C588 0A3BF440 0BD9C8C8 [........@.;.....]*
*BD9C630 0269BEFC 03296BD8 FFFFFFFF [..i..k).....]*
*========== FRAME [3] (_ksfdmp+14 -> _ksedmp+0) ==========*
Dump of memory from 0x0BD9C63C to 0x0BD9C648
Edited by: Yogesh_Nigal on Oct 16, 2012 10:12 AM