[root@test ~]# cd /opt/app/Oracle/admin/wolf
[root@test wolf]# ls
adump bdump cdump dpdump pfile udump
[root@test wolf]# cd udump/
[root@test udump]# ls
wolf_ora_18566.trc wolf_ora_19120.trc wolf_ora_4952.trc wolf_ora_5792.trc
wolf_ora_18605.trc wolf_ora_19790.trc wolf_ora_4954.trc wolf_ora_5826.trc
wolf_ora_18608.trc wolf_ora_19818.trc wolf_ora_5721.trc wolf_ora_5833.trc
wolf_ora_19087.trc wolf_ora_19820.trc wolf_ora_5764.trc wolf_ora_5860.trc
wolf_ora_19114.trc wolf_ora_4899.trc wolf_ora_5766.trc wolf_ora_9291.trc
[root@test udump]# ls -l
total 272
-rw-r----- 1 oracle oinstall 593 Jul 8 05:56 wolf_ora_18566.trc
-rw-r----- 1 oracle oinstall 650 Jul 8 05:56 wolf_ora_18605.trc
-rw-r----- 1 oracle oinstall 1872 Jul 8 06:05 wolf_ora_18608.trc
-rw-r----- 1 oracle oinstall 593 Jul 8 04:05 wolf_ora_19087.trc
-rw-r----- 1 oracle oinstall 650 Jul 8 04:05 wolf_ora_19114.trc
-rw-r----- 1 oracle oinstall 196171 Jul 8 04:21 wolf_ora_19120.trc
-rw-r----- 1 oracle oinstall 593 Jul 8 06:29 wolf_ora_19790.trc
-rw-r----- 1 oracle oinstall 650 Jul 8 06:29 wolf_ora_19818.trc
-rw-r----- 1 oracle oinstall 3331 Jul 8 11:08 wolf_ora_19820.trc
-rw-r----- 1 oracle oinstall 619 Jul 14 05:25 wolf_ora_4899.trc
-rw-r----- 1 oracle oinstall 648 Jul 14 05:25 wolf_ora_4952.trc
-rw-r----- 1 oracle oinstall 2717 Jul 14 05:36 wolf_ora_4954.trc
-rw-r----- 1 oracle oinstall 591 Jul 7 10:02 wolf_ora_5721.trc
-rw-r----- 1 oracle oinstall 907 Jul 7 10:03 wolf_ora_5764.trc
-rw-r----- 1 oracle oinstall 591 Jul 7 10:03 wolf_ora_5766.trc
-rw-r----- 1 oracle oinstall 2630 Jul 7 10:03 wolf_ora_5792.trc
-rw-r----- 1 oracle oinstall 776 Jul 7 10:03 wolf_ora_5826.trc
-rw-r----- 1 oracle oinstall 591 Jul 7 10:03 wolf_ora_5833.trc
-rw-r----- 1 oracle oinstall 648 Jul 7 10:04 wolf_ora_5860.trc
-rw-r----- 1 oracle oinstall 2045 Jul 8 04:04 wolf_ora_9291.trc
[root@test udump]# date
Sat Jul 14 05:38:57 EDT 2012
[root@test udump]# cat wolf_ora_4954.trc | more
/opt/app/oracle/admin/wolf/udump/wolf_ora_4954.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/app/oracle/product/10g
System name: Linux
Node name: test
Release: 2.6.18-128.el5
Version: #1 SMP Wed Dec 17 11:42:39 EST 2008
Machine: i686
Instance name: wolf
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 4954, image: oracle@test (TNS V1-V3)
*** 2012-07-14 05:36:52.410
*** SERVICE NAME:(SYS$USERS) 2012-07-14 05:36:52.410
*** SESSION ID:(159.3) 2012-07-14 05:36:52.410
Start dump data blocks tsn: 6 file#: 5 minblk 12 maxblk 12
buffer tsn: 6 rdba: 0x0140000c (5/12)
scn: 0x0000.0007e543 seq: 0x05 flg: 0x02 tail: 0xe5430605
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0CEF4200 to 0x0CEF6200
CEF4200 0000A206 0140000C 0007E543 02050000 [......@.C.......]
CEF4210 00000000 00000001 0000C8B1 0007E52C [............,...]
CEF4220 00000000 00320002 01400009 00230007 [......2...@...#.]
CEF4230 000000DD 0080077F 003400CC 00002003 [..........4.. ..]
CEF4240 0007E543 00000000 00000000 00000000 [C...............]
CEF4250 00000000 00000000 00000000 00000000 [................]
CEF4260 00000000 00030100 0018FFFF 1F651F80 [..............e.]
CEF4270 00001F65 1F900003 1F801F88 00000000 [e...............]
CEF4280 00000000 00000000 00000000 00000000 [................]
Repeat 501 times
CEF61E0 00000000 0202012C 630104C1 0202012C [....,......c,...]
CEF61F0 620103C1 0202012C 610102C1 E5430605 [...b,......a..C.]
Block header dump:0x0140000c
Object id on Block? Y
seg/obj: 0xc8b1 csc: 0x00.7e52c itc: 2 flg: E typ: 1 - DATA
brn: 0 bdba: 0x1400009 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0007.023.000000dd 0x0080077f.00cc.34 --U- 3 fsc 0x0000.0007e543
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
data_block_dump,data header at 0xcef4264
===============
tsiz: 0x1f98
hsiz: 0x18
pbl: 0x0cef4264
bdba: 0x0140000c
76543210
flag=--------
ntab=1
nrow=3
frre=-1
fsbo=0x18
fseo=0x1f80
avsp=0x1f65
tosp=0x1f65
0xe:pti[0] nrow=3 offs=0
0x12:pri[0] offs=0x1f90
0x14:pri[1] offs=0x1f88
0x16:pri[2] offs=0x1f80
block_row_dump:
tab 0, row 0, @0x1f90
tl: 8 fb: --H-FL-- lb: 0x1 cc: 2
col 0: [ 2] c1 02
col 1: [ 1] 61
tab 0, row 1, @0x1f88
tl: 8 fb: --H-FL-- lb: 0x1 cc: 2
col 0: [ 2] c1 03
col 1: [ 1] 62
tab 0, row 2, @0x1f80
tl: 8 fb: --H-FL-- lb: 0x1 cc: 2
col 0: [ 2] c1 04
col 1: [ 1] 63
end_of_block_dump
End dump data blocks tsn: 6 file#: 5 minblk 12 maxblk 12