Hello all,
We have been getting some error on the app side (locking issues) and the trace file is being generated in the udump...part of the trace file is below...how can we read this ?? i c the file# is 9 ...and then obj: 26828 ...but cant find that specific object in dba_segments.... i tried googling some stuff, but not a lot of article on reading bloc dumps....any help or all opinion are welcome...
Dump of buffer cache at level 10
BH (0x1CFD992C) file#: 9 rdba: 0x024199cc (9/104908) class 1 ba: 0x1C94A000
set: 3 dbwrid: 0 obj: 26828 objn: 25071
hash: [2a7d6218,3aacc0f4] lru: [1f7e86a8,27fe1418]
ckptq: [NULL] fileq: [NULL]
st: CR md: NULL rsop: 0x00000000 tch: 1
cr:[[scn: 0x000c.c1f6f2ee],[xid: 0x000a.010.0011f647],[uba: 0x0080327f.ab53.0b],[cls: 0x000c.c1f6f2f1],[sfl: 0x0]]
flags: buffer_dirty only_sequential_access
buffer tsn: 9 rdba: 0x024199cc (9/104908)
scn: 0x000c.c1f6f2f2 seq: 0x00 flg: 0x00 tail: 0xf2f20600
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Block header dump: 0x024199cc
Object id on Block? Y
seg/obj: 0x68cc csc: 0x0c.c1939250 itc: 6 flg: O typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
i am on 9.2.0.6 on win
Edited by: S2K on Jun 30, 2009 8:28 AM