11.1.0.6
$ORACLE_HOME/diag/rdbms/dbname/trace目录下产生很多trace文件,有的文件几百G
哪位高手解读下trace文件内容?
trace文件产生的原因?
贴一部分出来
ncol: 16 nnew: 4 size: 0
col 5: *NULL*
col 6: [ 1] 41
col 7: [ 3] c2 31 3e
col 9: [ 4] c3 0b 3c 37
CHANGE #45 TYP:0 CLS:58 AFN:3 DBA:0x00c00b58 OBJ:4294967295 SCN:0x0000.078cb532 SEQ: 9 OP:5.1 ENC:0
ktudb redo: siz: 112 spc: 7124 flg: 0x0022 seq: 0x0067 rec: 0x0a
xid: 0x0015.017.00000154
ktubu redo: slt: 23 rci: 9 opc: 11.1 objn: 82215 objd: 82215 tsn: 5
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c00b58.0067.09
KDO Op code: URP row dependencies Disabled
xtype: XA f