Ora-00600[KGHLKREM1]
现象：
alert日志报错：
Sat May 18 07:59:47 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3690630.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:51 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_4530210.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Sat May 18 07:59:52 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_4571226.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3580036.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/background/PP_smon_3174646.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3690634.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Sat May 18 07:59:59 2013
Errors in file /oracle/PP/saptrace/background/PP_pmon_3006490.trc:
ORA-00474: SMON process terminated with error
Sat May 18 07:59:59 2013
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 3006490
PP_ora_3477608.trc信息：
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
ORACLE_HOME = /oracle/PP/102_64
System name: AIX
Node name: ppserver01
Release: 3
Version: 5
Machine: 00C2E56F4C00
Instance name: PP
Redo thread mounted by this instance: 1
Oracle process number: 38
Unix process pid: 3477608, image: oraclePP@ppserver01
*** 2013-05-18 07:49:04.855
*** ACTION NAME:(298) 2013-05-18 07:49:04.854
*** MODULE NAME:(GP4IV83BY2WCKQIJN2P2XT31F5T) 2013-05-18 07:49:04.854
*** SERVICE NAME:(SYS$USERS) 2013-05-18 07:49:04.854
*** SESSION ID:(1252.62448) 2013-05-18 07:49:04.854
***** Internal heap ERROR KGHLKREM1 addr=7000008c2000020 ds=700000010000058 *****
***** Dump of memory around addr 7000008c2000020:
7000008C2000000 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7000008C2000020 07000000 10001990 00000000 00000000 [................]
7000008C2000030 00000000 00000000 00000000 00000000 [................]
******************************************************
HEAP DUMP heap name="sga heap" desc=700000010000058
extent sz=0xfe0 alt=216 het=32767 rec=9 flg=-126 opc=4
parent=0 owner=0 nex=0 xsz=0x20
*** 2013-05-18 07:49:04.866
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Current SQL statement for this session:
SELECT /*+ FIRST_ROWS(1) */ "COMP_CODE" , "CHRT_ACCTS" , "GL_ACCOUNT" , "FISCVARNT" , "FISCPER" , "AC_DOC_NO" , "ITEM_NUM" , "FI_DOCSTAT" , "ACCT_TYPE" , "SP_GL_IND" , "AC_DOC_TYP" , "POST_KEY" , "DOC_DATE" , "PSTNG_DATE" , "CREATEDON" , "CLEAR_DATE" , "CLR_DOC_NO" , "CO_AREA" , "COSTCENTER" , "PROFIT_CTR" , "COORDER" , "WBS_ELEMT" , "PLANT" , "BUS_AREA" , "FUNC_AREA" , "PART_PRCTR" , "PCOMPANY" , "PBUS_AREA" , "LOC_CURRCY" , "DEBIT_LC" , "CREDIT_LC" , "DEB_CRE_LC" , "DOC_CURRCY" , "DEBIT_DC" , "CREDIT_DC" , "DEB_CRE_DC" , "LOC_CURTP2" , "LOC_CURRC2" , "DEBIT_LC2" , "CREDIT_LC2" , "DEB_CRE_L2" , "LOC_CURTP3" , "LOC_CURRC3" , "DEBIT_LC3" , "CREDIT_LC3" , "DEB_CRE_L3" , "REF_DOC_NO" , "REF_KEY3" , "ORG_DOC_NO" , "ORG_DOC_YR" , "ORG_DOC_CC" , "ORG_DOC_CO" , "RECORDMODE" , "ALLOC_NMBR" , "POSTXT" , "USERNAME" , "DOC_HD_TXT" , "ASSET_MAIN" , "ASSET" , "REASON_CDE" , "/BIC/ZTCODE" , "FI_DBCRIND" , "/BIC/ZAWKEY" FROM "/BIC/AFI00_O0000" WHERE "COMP_CODE" = :A0 AND "CHRT_ACCTS" = :A1 AND "GL_ACCOUNT" = :A2 AND "FISCVARNT" = :A3 AND "FISCPER" = :A4 AND "AC_DOC_NO" = :A5 AND "ITEM_NUM" = :A6
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
kghnerror+0470 bl kgesin 11016A6C8 ? 10430E2AC ? <===Call stack：kghnerror kghadd_reserved_extent kghget_reserved_extent kghgex kghfnd kghalo kghgex kghalf kghalp kglsal kglsadd
000000000 ? 100000001 ?
000000002 ? 7000008C2000020 ?
000000000 ? 000000000 ?
kghadd_reserved_ext bl kghnerror 000000000 ? 700000010003B98 ?
ent+0244 1100012A8 ? 7000000100F91F8 ?
kghget_reserved_ext bl kghadd_reserved_ext 000000000 ? 7000009C975E740 ?
ent+0214 ent 00000001B ? 000000000 ?
00000001B ? 000000008 ?
kghgex+0534 bl kghget_reserved_ext FFFFFFFFFFEA3D0 ? 1101F0240 ?
ent 1102273A0 ? 700000997C995F0 ?
000008000 ?
kghfnd+05ac bl kghgex FFFFFFFFFFEA4C0 ? 0000008E8 ?
000000018 ? 000000001 ?
000000001 ? 000000000 ?
09007AFFF ?
kghalo+0a14 bl kghfnd 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
kghgex+036c bl kghalo 000000002 ? 000000000 ?
7000009C975E740 ? 00000000B ?
0000000C7 ? FFFFFFFFFEAEB8 ?
FFFFFFFFFFEAC98 ? 00C87A838 ?
kghalf+0460 bl kghgex 000008000 ? 1043EC0FC ?
1043EC0F4 ? 70000080C9B02E0 ?
000000000 ? 000000090 ?
70000080C9B02E8 ?
kghalp+0278 bl kghalf 000000000 ? 70000080C87A838 ?
000000000 ? 000000005 ?
0000000AA ? FFFFFFFFFFEB080 ?
kglsal+00a4 bl kghalp 70000080C9B02E8 ? 000000004 ?
000000000 ? 70000080C87A838 ?
70000080C87A906 ? 000000001 ?
kglsadd+00ec bl kglsal 70000080C87A906 ? 000000001 ?
----------------------------------------
SO: 7000009ca7702d0, type: 4, owner: 7000009c851ec40, flag: INIT/-/-/0x00
(session) sid: 1494 trans: 0, creator: 7000009c851ec40, flag: (1000041) USR/- -/-/-/-/-/-
DID: 0001-0026-00058CCA, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, sql: 0, psql: 700000946c2ba88, user: 27/SAPSR3
O/S info: user: PPadm, term: , ospid: 4649210, machine: ppserver01
program: dw.sapPP_DVEBMGS01@ppserver01 (TNS V1-V3)
client info: 1
application name: GP4F1RTDKREPXII6BJ25XA6U9K6, hash value=2112637063
action name: 82, hash value=2257323982
last wait for 'SQL*Net message from client' blocking sess=0x0 seq=45555 wait_time=142223 seconds since wait started=116
driver id=54435000, #bytes=1, =0
Dumping Session Wait History
for 'SQL*Net message from client' count=1 wait_time=142223
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=54435000, #bytes=1, =0
for 'log file sync' count=1 wait_time=26280
buffer#=2e98, =0, =0
for 'SQL*Net message from client' count=1 wait_time=191
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=54435000, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=267
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=54435000, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=242
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=54435000, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=361
driver id=54435000, #bytes=1, =0
temporary object counter: 0
----------------------------------------
******************** Session Cursor Dump **********************
Current cursor: 198, pgadep: 0
Open cursors(pls, sys, hwm, max): 236(0, 3, 256, 2000)
NULL 9 SYNTAX 1 PARSE 0 BOUND 223 FETCH 0 ROW 3
Cached frame pages(total, free):
4k(20, 18), 8k(1, 1), 16k(1, 1), 32k(0, 0)
pgactx: 70000095492a1d8 ctxcbk: 0 ctxqbc: 11050ab98 ctxrws: 0
----------------------------------------
Cursor#198(110613388) state=SYNTAX curiob=11062f3f8
curflg=4e fl2=0 par=0 ses=7000009c971af60
child cursor: 170
sqltxt(7000008e336c8a0)=
SELECT /*+ FIRST_ROWS(1) */ "COMP_CODE" , "CHRT_ACCTS" , "GL_ACCOUNT" , "FISCVARNT" , "FISCPER" , "AC_DOC_NO" , "ITEM_NUM" , "FI_DOCSTAT" , "ACCT_TYPE" , "SP_GL_IND" , "AC_DOC_TYP" , "POST_KEY" , "DOC_DATE" , "PSTNG_DATE" , "CREATEDON" , "CLEAR_DATE" , "CLR_DOC_NO" , "CO_AREA" , "COSTCENTER" , "PROFIT_CTR" , "COORDER" , "WBS_ELEMT" , "PLANT" , "BUS_AREA" , "FUNC_AREA" , "PART_PRCTR" , "PCOMPANY" , "PBUS_AREA" , "LOC_CURRCY" , "DEBIT_LC" , "CREDIT_LC" , "DEB_CRE_LC" , "DOC_CURRCY" , "DEBIT_DC" , "CREDIT_DC" , "DEB_CRE_DC" , "LOC_CURTP2" , "LOC_CURRC2" , "DEBIT_LC2" , "CREDIT_LC2" , "DEB_CRE_L2" , "LOC_CURTP3" , "LOC_CURRC3" , "DEBIT_LC3" , "CREDIT_LC3" , "DEB_CRE_L3" , "REF_DOC_NO" , "REF_KEY3" , "ORG_DOC_NO" , "ORG_DOC_YR" , "ORG_DOC_CC" , "ORG_DOC_CO" , "RECORDMODE" , "ALLOC_NMBR" , "POSTXT" , "USERNAME" , "DOC_HD_TXT" , "ASSET_MAIN" , "ASSET" , "REASON_CDE" , "/BIC/ZTCODE" , "FI_DBCRIND" , "/BIC/ZAWKEY" FROM "/BIC/AFI00_O0000" WHERE "COMP_CODE" = :A0 AND "CHRT_ACCTS" = :A1 AND "GL_ACCOUNT" = :A2 AND "FISCVARNT" = :A3 AND "FISCPER" = :A4 AND "AC_DOC_NO" = :A5 AND "ITEM_NUM" = :A6
hash=e827ac0da76d2a7a9df64f5504a0c7dc
parent=7000009b5e24428 maxchild=03 plk=7000009b896ab70 ppn=n
cursor instantiation=11062f3f8 used=1368834544
child#0(7000008a97c3438) pcs=7000009b5e24038
clk=7000009b878e490 ci=7000009b5e23720 pn=700000946425768 ctx=70000095492a1d8
kgsccflg=0 llk[11062f400,11062f400] idx=0
xscflg=130437 fl2=41240009 fl3=2022000 fl4=80
Bind bytecodes
kkscoacd
Bind#0
oacdty=96 mxl=32(12) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=224 off=0
No bind buffers allocated
Bind#1
oacdty=96 mxl=32(12) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=32
No bind buffers allocated
Bind#2
oacdty=96 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=64
No bind buffers allocated
Bind#3
oacdty=96 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=96
No bind buffers allocated
Bind#4
oacdty=96 mxl=32(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=128
No bind buffers allocated
Bind#5
oacdty=96 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=160
No bind buffers allocated
Bind#6
oacdty=96 mxl=32(09) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=192
No bind buffers allocated
Frames pfr 110547e90 siz=10056 efr 110547dc0 siz=10032
Cursor frame dump
enxt: 5.0x00000010
pnxt: 2.0x00000008 pnxt: 1.0x00000010
kxscphp 1106b4dc8 siz=6552 inu=6000 nps=5856
kxscdfhp 1105b5be0 siz=984 inu=88 nps=0
分析：
符合Oracle的一个已知的BUG：
Bug 6137313 : SMON CRASHED WITH ORA-600 [KGHLKREMF()+33] AFTER ORA-600 [KGHLKREM1]
BUG:5736850 MULTI KILL SESSION LEADS TO SGA CORRUPTION
Oracle提供的解决方法：
1. Upgrade to a supported release, 11.2.0.3
or
2. Apply the 10.2.0.5.0 patchset
or
3. Use the known workaround of setting:
SQL> alter system set "_bloom_filter_enabled"=false scope=both;
现象：
alert日志报错：
Sat May 18 07:59:47 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3690630.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:51 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_4530210.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Sat May 18 07:59:52 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_4571226.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3580036.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/background/PP_smon_3174646.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3690634.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Sat May 18 07:59:59 2013
Errors in file /oracle/PP/saptrace/background/PP_pmon_3006490.trc:
ORA-00474: SMON process terminated with error
Sat May 18 07:59:59 2013
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 3006490
PP_ora_3477608.trc信息：
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
ORACLE_HOME = /oracle/PP/102_64
System name: AIX
Node name: ppserver01
Release: 3
Version: 5
Machine: 00C2E56F4C00
Instance name: PP
Redo thread mounted by this instance: 1
Oracle process number: 38
Unix process pid: 3477608, image: oraclePP@ppserver01
*** 2013-05-18 07:49:04.855
*** ACTION NAME:(298) 2013-05-18 07:49:04.854
*** MODULE NAME:(GP4IV83BY2WCKQIJN2P2XT31F5T) 2013-05-18 07:49:04.854
*** SERVICE NAME:(SYS$USERS) 2013-05-18 07:49:04.854
*** SESSION ID:(1252.62448) 2013-05-18 07:49:04.854
***** Internal heap ERROR KGHLKREM1 addr=7000008c2000020 ds=700000010000058 *****
***** Dump of memory around addr 7000008c2000020:
7000008C2000000 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7000008C2000020 07000000 10001990 00000000 00000000 [................]
7000008C2000030 00000000 00000000 00000000 00000000 [................]
******************************************************
HEAP DUMP heap name="sga heap" desc=700000010000058
extent sz=0xfe0 alt=216 het=32767 rec=9 flg=-126 opc=4
parent=0 owner=0 nex=0 xsz=0x20
*** 2013-05-18 07:49:04.866
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Current SQL statement for this session:
SELECT /*+ FIRST_ROWS(1) */ "COMP_CODE" , "CHRT_ACCTS" , "GL_ACCOUNT" , "FISCVARNT" , "FISCPER" , "AC_DOC_NO" , "ITEM_NUM" , "FI_DOCSTAT" , "ACCT_TYPE" , "SP_GL_IND" , "AC_DOC_TYP" , "POST_KEY" , "DOC_DATE" , "PSTNG_DATE" , "CREATEDON" , "CLEAR_DATE" , "CLR_DOC_NO" , "CO_AREA" , "COSTCENTER" , "PROFIT_CTR" , "COORDER" , "WBS_ELEMT" , "PLANT" , "BUS_AREA" , "FUNC_AREA" , "PART_PRCTR" , "PCOMPANY" , "PBUS_AREA" , "LOC_CURRCY" , "DEBIT_LC" , "CREDIT_LC" , "DEB_CRE_LC" , "DOC_CURRCY" , "DEBIT_DC" , "CREDIT_DC" , "DEB_CRE_DC" , "LOC_CURTP2" , "LOC_CURRC2" , "DEBIT_LC2" , "CREDIT_LC2" , "DEB_CRE_L2" , "LOC_CURTP3" , "LOC_CURRC3" , "DEBIT_LC3" , "CREDIT_LC3" , "DEB_CRE_L3" , "REF_DOC_NO" , "REF_KEY3" , "ORG_DOC_NO" , "ORG_DOC_YR" , "ORG_DOC_CC" , "ORG_DOC_CO" , "RECORDMODE" , "ALLOC_NMBR" , "POSTXT" , "USERNAME" , "DOC_HD_TXT" , "ASSET_MAIN" , "ASSET" , "REASON_CDE" , "/BIC/ZTCODE" , "FI_DBCRIND" , "/BIC/ZAWKEY" FROM "/BIC/AFI00_O0000" WHERE "COMP_CODE" = :A0 AND "CHRT_ACCTS" = :A1 AND "GL_ACCOUNT" = :A2 AND "FISCVARNT" = :A3 AND "FISCPER" = :A4 AND "AC_DOC_NO" = :A5 AND "ITEM_NUM" = :A6
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
kghnerror+0470 bl kgesin 11016A6C8 ? 10430E2AC ? <===Call stack：kghnerror kghadd_reserved_extent kghget_reserved_extent kghgex kghfnd kghalo kghgex kghalf kghalp kglsal kglsadd
000000000 ? 100000001 ?
000000002 ? 7000008C2000020 ?
000000000 ? 000000000 ?
kghadd_reserved_ext bl kghnerror 000000000 ? 700000010003B98 ?
ent+0244 1100012A8 ? 7000000100F91F8 ?
kghget_reserved_ext bl kghadd_reserved_ext 000000000 ? 7000009C975E740 ?
ent+0214 ent 00000001B ? 000000000 ?
00000001B ? 000000008 ?
kghgex+0534 bl kghget_reserved_ext FFFFFFFFFFEA3D0 ? 1101F0240 ?
ent 1102273A0 ? 700000997C995F0 ?
000008000 ?
kghfnd+05ac bl kghgex FFFFFFFFFFEA4C0 ? 0000008E8 ?
000000018 ? 000000001 ?
000000001 ? 000000000 ?
09007AFFF ?
kghalo+0a14 bl kghfnd 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
kghgex+036c bl kghalo 000000002 ? 000000000 ?
7000009C975E740 ? 00000000B ?
0000000C7 ? FFFFFFFFFEAEB8 ?
FFFFFFFFFFEAC98 ? 00C87A838 ?
kghalf+0460 bl kghgex 000008000 ? 1043EC0FC ?
1043EC0F4 ? 70000080C9B02E0 ?
000000000 ? 000000090 ?
70000080C9B02E8 ?
kghalp+0278 bl kghalf 000000000 ? 70000080C87A838 ?
000000000 ? 000000005 ?
0000000AA ? FFFFFFFFFFEB080 ?
kglsal+00a4 bl kghalp 70000080C9B02E8 ? 000000004 ?
000000000 ? 70000080C87A838 ?
70000080C87A906 ? 000000001 ?
kglsadd+00ec bl kglsal 70000080C87A906 ? 000000001 ?
----------------------------------------
SO: 7000009ca7702d0, type: 4, owner: 7000009c851ec40, flag: INIT/-/-/0x00
(session) sid: 1494 trans: 0, creator: 7000009c851ec40, flag: (1000041) USR/- -/-/-/-/-/-
DID: 0001-0026-00058CCA, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, sql: 0, psql: 700000946c2ba88, user: 27/SAPSR3
O/S info: user: PPadm, term: , ospid: 4649210, machine: ppserver01
program: dw.sapPP_DVEBMGS01@ppserver01 (TNS V1-V3)
client info: 1
application name: GP4F1RTDKREPXII6BJ25XA6U9K6, hash value=2112637063
action name: 82, hash value=2257323982
last wait for 'SQL*Net message from client' blocking sess=0x0 seq=45555 wait_time=142223 seconds since wait started=116
driver id=54435000, #bytes=1, =0
Dumping Session Wait History
for 'SQL*Net message from client' count=1 wait_time=142223
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=54435000, #bytes=1, =0
for 'log file sync' count=1 wait_time=26280
buffer#=2e98, =0, =0
for 'SQL*Net message from client' count=1 wait_time=191
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=54435000, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=267
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=54435000, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=242
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=1
driver id=54435000, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=361
driver id=54435000, #bytes=1, =0
temporary object counter: 0
----------------------------------------
******************** Session Cursor Dump **********************
Current cursor: 198, pgadep: 0
Open cursors(pls, sys, hwm, max): 236(0, 3, 256, 2000)
NULL 9 SYNTAX 1 PARSE 0 BOUND 223 FETCH 0 ROW 3
Cached frame pages(total, free):
4k(20, 18), 8k(1, 1), 16k(1, 1), 32k(0, 0)
pgactx: 70000095492a1d8 ctxcbk: 0 ctxqbc: 11050ab98 ctxrws: 0
----------------------------------------
Cursor#198(110613388) state=SYNTAX curiob=11062f3f8
curflg=4e fl2=0 par=0 ses=7000009c971af60
child cursor: 170
sqltxt(7000008e336c8a0)=
SELECT /*+ FIRST_ROWS(1) */ "COMP_CODE" , "CHRT_ACCTS" , "GL_ACCOUNT" , "FISCVARNT" , "FISCPER" , "AC_DOC_NO" , "ITEM_NUM" , "FI_DOCSTAT" , "ACCT_TYPE" , "SP_GL_IND" , "AC_DOC_TYP" , "POST_KEY" , "DOC_DATE" , "PSTNG_DATE" , "CREATEDON" , "CLEAR_DATE" , "CLR_DOC_NO" , "CO_AREA" , "COSTCENTER" , "PROFIT_CTR" , "COORDER" , "WBS_ELEMT" , "PLANT" , "BUS_AREA" , "FUNC_AREA" , "PART_PRCTR" , "PCOMPANY" , "PBUS_AREA" , "LOC_CURRCY" , "DEBIT_LC" , "CREDIT_LC" , "DEB_CRE_LC" , "DOC_CURRCY" , "DEBIT_DC" , "CREDIT_DC" , "DEB_CRE_DC" , "LOC_CURTP2" , "LOC_CURRC2" , "DEBIT_LC2" , "CREDIT_LC2" , "DEB_CRE_L2" , "LOC_CURTP3" , "LOC_CURRC3" , "DEBIT_LC3" , "CREDIT_LC3" , "DEB_CRE_L3" , "REF_DOC_NO" , "REF_KEY3" , "ORG_DOC_NO" , "ORG_DOC_YR" , "ORG_DOC_CC" , "ORG_DOC_CO" , "RECORDMODE" , "ALLOC_NMBR" , "POSTXT" , "USERNAME" , "DOC_HD_TXT" , "ASSET_MAIN" , "ASSET" , "REASON_CDE" , "/BIC/ZTCODE" , "FI_DBCRIND" , "/BIC/ZAWKEY" FROM "/BIC/AFI00_O0000" WHERE "COMP_CODE" = :A0 AND "CHRT_ACCTS" = :A1 AND "GL_ACCOUNT" = :A2 AND "FISCVARNT" = :A3 AND "FISCPER" = :A4 AND "AC_DOC_NO" = :A5 AND "ITEM_NUM" = :A6
hash=e827ac0da76d2a7a9df64f5504a0c7dc
parent=7000009b5e24428 maxchild=03 plk=7000009b896ab70 ppn=n
cursor instantiation=11062f3f8 used=1368834544
child#0(7000008a97c3438) pcs=7000009b5e24038
clk=7000009b878e490 ci=7000009b5e23720 pn=700000946425768 ctx=70000095492a1d8
kgsccflg=0 llk[11062f400,11062f400] idx=0
xscflg=130437 fl2=41240009 fl3=2022000 fl4=80
Bind bytecodes
kkscoacd
Bind#0
oacdty=96 mxl=32(12) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=224 off=0
No bind buffers allocated
Bind#1
oacdty=96 mxl=32(12) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=32
No bind buffers allocated
Bind#2
oacdty=96 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=64
No bind buffers allocated
Bind#3
oacdty=96 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=96
No bind buffers allocated
Bind#4
oacdty=96 mxl=32(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=128
No bind buffers allocated
Bind#5
oacdty=96 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=160
No bind buffers allocated
Bind#6
oacdty=96 mxl=32(09) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=192
No bind buffers allocated
Frames pfr 110547e90 siz=10056 efr 110547dc0 siz=10032
Cursor frame dump
enxt: 5.0x00000010
pnxt: 2.0x00000008 pnxt: 1.0x00000010
kxscphp 1106b4dc8 siz=6552 inu=6000 nps=5856
kxscdfhp 1105b5be0 siz=984 inu=88 nps=0
分析：
符合Oracle的一个已知的BUG：
Bug 6137313 : SMON CRASHED WITH ORA-600 [KGHLKREMF()+33] AFTER ORA-600 [KGHLKREM1]
BUG:5736850 MULTI KILL SESSION LEADS TO SGA CORRUPTION
Oracle提供的解决方法：
1. Upgrade to a supported release, 11.2.0.3
or
2. Apply the 10.2.0.5.0 patchset
or
3. Use the known workaround of setting:
SQL> alter system set "_bloom_filter_enabled"=false scope=both;
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
