Dump File

Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as nod32
 
SQL> Drop Table A ;
 
Table dropped
 
SQL> Create Table A (A Number(8)) ;
 
Table created
 
SQL> Create Index Idx_A On A(A) ;
 
Index created
 
SQL> Insert Into A Values (1) ;
 
1 row inserted
 
SQL> Insert Into A Values (3) ;
 
1 row inserted
 
SQL> Insert Into A Values (4) ;
 
1 row inserted
 
SQL> Commit ;
 
Commit complete
 
SQL> Select Segment_Name,Header_File,Header_Block From Dba_Segments Where Segment_Name = 'IDX_A' ;
 
SEGMENT_NAME   HEADER_FILE HEADER_BLOCK
-------------------------- --------------------- ------------------------
IDX_A                                                   5                         123
 
SQL> Alter Session Set Tracefile_Identifier = 'Look For A....124';
 
Session altered
 
SQL> Alter System Dump Datafile 5 Block Min 124 Block Max 124;
 
System altered
 
Context Of Trace_File 'Look For A....124'

*** TRACE DUMP CONTINUED FROM FILE d:\oracle\product\10.1.0\admin\nod32\udump\nod32_ora_2356_look for a....118.trc ***

*** 2009-10-01 10:25:24.453
Start dump data blocks tsn: 4 file#: 5 minblk 124 maxblk 124
buffer tsn: 4 rdba: 0x0140007c (5/124)
scn: 0x0000.0014e941 seq: 0x04 flg: 0x06 tail: 0xe9410604
frmt: 0x02 chkval: 0x1a09 type: 0x06=trans data
Block header dump:  0x0140007c
 Object id on Block? Y
 seg/obj: 0xc483  csc: 0x00.14e8f0  itc: 2  flg: E  typ: 2 - INDEX
     brn: 0  bdba: 0x1400079 ver: 0x01 opc: 0
     inc: 0  exflg: 0
 
 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
0x02   0x0004.001.00000364  0x008000c4.029b.18  --U-    3  fsc 0x0000.0014e941
 
Leaf block dump
===============
header address 119603812=0x7210264
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 8000=0x1f40
kdxcoavs 7958
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 2, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  01 40 00 74 00 00
row#1[8012] flag: ------, lock: 2, len=12
col 0; len 2; (2):  c1 04
col 1; len 6; (6):  01 40 00 74 00 01
row#2[8000] flag: ------, lock: 2, len=12
col 0; len 2; (2):  c1 05
col 1; len 6; (6):  01 40 00 74 00 02
----- end of leaf block dump -----
End dump data blocks tsn: 4 file#: 5 minblk 124 maxblk 124

SQL> Delete From A Where A = 3 ;
 
1 row deleted
 
SQL> Commit ;
 
Commit complete
 
SQL> Alter Session Set Tracefile_Identifier = 'Look For A....After 124';
 
Session altered
 
SQL> Alter System Dump Datafile 5 Block Min 124 Block Max 124;
 
System altered

Context Of Trace_File 'Look For A....After 124'

*** TRACE DUMP CONTINUED FROM FILE d:\oracle\product\10.1.0\admin\nod32\udump\nod32_ora_2356_look for a....124.trc ***

*** 2009-10-01 10:28:14.593
Start dump data blocks tsn: 4 file#: 5 minblk 124 maxblk 124
buffer tsn: 4 rdba: 0x0140007c (5/124)
scn: 0x0000.0014ec52 seq: 0x02 flg: 0x02 tail: 0xec520602
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Block header dump:  0x0140007c
 Object id on Block? Y
 seg/obj: 0xc483  csc: 0x00.14ec4f  itc: 2  flg: E  typ: 2 - INDEX
     brn: 0  bdba: 0x1400079 ver: 0x01 opc: 0
     inc: 0  exflg: 0
 
 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
0x02   0x0004.009.00000365  0x008000c8.029b.07  --U-    1  fsc 0x000e.0014ec52
 
Leaf block dump
===============
header address 119603812=0x7210264
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 8000=0x1f40
kdxcoavs 7958
kdxlespl 0
kdxlende 1
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  01 40 00 74 00 00
row#1[8012] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 04
col 1; len 6; (6):  01 40 00 74 00 01
row#2[8000] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 05
col 1; len 6; (6):  01 40 00 74 00 02
----- end of leaf block dump -----
End dump data blocks tsn: 4 file#: 5 minblk 124 maxblk 124

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21184539/viewspace-615924/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21184539/viewspace-615924/