---找到报错SQL的绑定变量
7FFF83DBDC10 ? 7FFF83DBDC7
Cursor#4(0x2b40803017f8) state=FETCH curiob=0x2b4080319810
curflg=7 fl2=200000 par=0x2b4080301790 ses=0x95b88508
sqltxt(0x954f6068)=
select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner#
hash=767439bb115ad4a42c7b76fafb52493f
parent=0x901ff978 maxchild=01 plk=0x90f88f30 ppn=n
cursor instantiation=0x2b4080319810 used=1448950509
child#0(0x954f5ee0) pcs=0x901fef98
clk=0x90f8c480 ci=0x901fec70 pn=0x954f7198 ctx=0x8fb289f0
kgsccflg=1 llk[0x2b4080319818,0x2b4080319818] idx=40
xscflg=e0141476 fl2=5000401 fl3=4022210c fl4=100
Bind bytecodes
Opcode = 1 Unoptimized
Offsi = 48, Offsi = 0
Opcode = 1 Unoptimized
Offsi = 48, Offsi = 32
kkscoacd
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=2b4080603d78 bln=22 avl=03 flg=05
value=4365
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=2b4080603d48 bln=24 avl=02 flg=05
value=3
---还是没有什么实质的思路，回过头再看报错的ORA-600 2662的TRC文件的其它内容
--发现还有UNDO BLOCK的信息
UNDO BLK:
xid: 0x0006.011.000000b5 seq: 0x57 cnt: 0x3 irb: 0x3 icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f70 0x02 0x1f1c 0x03 0x1e98
*-----------------------------
* Rec #0x1 slt: 0x2d objn: 257(0x00000101) objd: 257 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 21 rci 0x00
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00800060
*-----------------------------
index general undo (branch) operations
KTB Redo
op: 0x05 ver: 0x01
op: R itc: 2
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
Dump kdige : block dba :0x0040a7ba, seghdr dba: 0x00400819
make leaf block empty
(2): 01 00
*-----------------------------
* Rec #0x2 slt: 0x2d objn: 257(0x00000101) objd: 257 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 21 rci 0x01
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index general undo (branch) operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0006.013.0000008a uba: 0x008064fc.0023.02
flg: C--- lkc: 0 scn: 0x0000.00033cd2
Dump kdige : block dba :0x0040081a, seghdr dba: 0x00400819
branch block row purge
(4): 01 00 1e 00
*-----------------------------
* Rec #0x3 slt: 0x11 objn: 256(0x00000100) objd: 256 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 21 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x0080005f.0056.01 ctl max scn: 0x0000.0004914b prv tx scn: 0x0000.0004914d
txn start scn: scn: 0x0000.0004a85f logon user: 0
prev brb: 0 prev bcl: 0
index general undo (branch) operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0006.016.0000008a uba: 0x008064fe.0023.01
flg: CB-- lkc: 0 scn: 0x0000.00033cd5
Dump kdige : block dba :0x0040a7c1, seghdr dba: 0x00400811
unlock block
(1): 01
----------------------------------------
SO: 0x944a5578, type: 24, owner: 0x95bb9558, flag: INIT/-/-/0x00
(buffer) (CR) PR: 0x95a6ba30 FLG: 0x100000
class bit: (nil)
kcbbfbp: [BH: 0x877ed898, LINK: 0x944a55b8]
where: kdiwh08: kdiixs, why: 0
BH (0x877ed898) file#: 1 rdba: 0x0040081a (1/2074) class: 1 ba: 0x87610000
set: 12 blksize: 8192 bsi: 0 set-flg: 2 pwbcnt: 4
dbwrid: 0 obj: 257 objn: 257 tsn: 0 afn: 1
hash: [94b10178,94b10178] lru: [877eda28,877ed808]
ckptq: [NULL] fileq: [NULL] objq: [90f57fc8,877ed218]
use: [944a55b8,944a55b8] wait: [NULL]
st: XCURRENT md: SHR tch: 3
flags:
LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
Using State Objects
----------------------------------------
SO: 0x944a5578, type: 24, owner: 0x95bb9558, flag: INIT/-/-/0x00
(buffer) (CR) PR: 0x95a6ba30 FLG: 0x100000
class bit: (nil)
kcbbfbp: [BH: 0x877ed898, LINK: 0x944a55b8]
where: kdiwh08: kdiixs, why: 0
buffer tsn: 0 rdba: 0x0040081a (1/2074)
scn: 0x0000.0004a862 seq: 0x01 flg: 0x04 tail: 0xa8620601
frmt: 0x02 chkval: 0x07dc type: 0x06=trans data
Hex dump of block: st=0, typ_found=1