对 Oracle 索引leaf block 进行dump
F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Apr 9 06:28:17 2015
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
06:39:43 sys@FS> alter session set events 'immediate trace name treedump level 95503'; ---->该95503是该索引的object_id
Session altered.
Elapsed: 00:00:01.38
06:39:52 sys@FS>
---->在udump下获得trc文件
Dump file f:\oracle\product\10.2.0\admin\fs\udump\fs_ora_4544.trc
Thu Apr 09 06:39:51 2015
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1
CPU : 4 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:4189M/7950M, Ph+PgF:11446M/16140M
Instance name: fs
Redo thread mounted by this instance: 1
Oracle process number: 24
Windows thread id: 4544, image: ORACLE.EXE (SHAD)
*** 2015-04-09 06:39:51.156
*** ACTION NAME:() 2015-04-09 06:39:51.138
*** MODULE NAME:(sqlplus.exe) 2015-04-09 06:39:51.138
*** SERVICE NAME:(SYS$USERS) 2015-04-09 06:39:51.138
*** SESSION ID:(1074.5) 2015-04-09 06:39:51.138
----- begin tree dump
branch: 0x100150c 16782604 (0: nrow: 178, level: 1)
leaf: 0x100150d 16782605 (-1: nrow: 288 rrow: 288)
leaf: 0x100150e 16782606 (0: nrow: 289 rrow: 289)
leaf: 0x100150f 16782607 (1: nrow: 288 rrow: 288)--->以此行为例子：0x100150f这是16进制的DBA；16782607 这是十进制的DBA
leaf: 0x1001510 16782608 (2: nrow: 288 rrow: 288)
leaf: 0x1001511 16782609 (3: nrow: 288 rrow: 288)
leaf: 0x1001512 16782610 (4: nrow: 288 rrow: 288)
leaf: 0x1001513 16782611 (5: nrow: 288 rrow: 288)
leaf: 0x1001514 16782612 (6: nrow: 288 rrow: 288)
leaf: 0x1001515 16782613 (7: nrow: 288 rrow: 288)
leaf: 0x1001516 16782614 (8: nrow: 288 rrow: 288)
leaf: 0x1001517 16782615 (9: nrow: 288 rrow: 288)
leaf: 0x1001518 16782616 (10: nrow: 288 rrow: 288)
leaf: 0x100151a 16782618 (11: nrow: 288 rrow: 288)
leaf: 0x100151b 16782619 (12: nrow: 288 rrow: 288)
leaf: 0x100151c 16782620 (13: nrow: 288 rrow: 288)
leaf: 0x100151d 16782621 (14: nrow: 288 rrow: 288)
leaf: 0x100151e 16782622 (15: nrow: 288 rrow: 288)
leaf: 0x100151f 16782623 (16: nrow: 288 rrow: 288)
leaf: 0x1001520 16782624 (17: nrow: 288 rrow: 288)
leaf: 0x1001521 16782625 (18: nrow: 288 rrow: 288)
leaf: 0x1001522 16782626 (19: nrow: 288 rrow: 288)
leaf: 0x1001523 16782627 (20: nrow: 288 rrow: 288)
leaf: 0x1001524 16782628 (21: nrow: 288 rrow: 288)
leaf: 0x1001525 16782629 (22: nrow: 288 rrow: 288)
leaf: 0x1001526 16782630 (23: nrow: 288 rrow: 288)
leaf: 0x1001527 16782631 (24: nrow: 288 rrow: 288)
leaf: 0x1001528 16782632 (25: nrow: 288 rrow: 288)
leaf: 0x100152a 16782634 (26: nrow: 288 rrow: 288)
leaf: 0x100152b 16782635 (27: nrow: 288 rrow: 288)
leaf: 0x100152c 16782636 (28: nrow: 288 rrow: 288)
leaf: 0x100152d 16782637 (29: nrow: 288 rrow: 288)
leaf: 0x100152e 16782638 (30: nrow: 288 rrow: 288)
leaf: 0x100152f 16782639 (31: nrow: 288 rrow: 288)
leaf: 0x1001530 16782640 (32: nrow: 288 rrow: 288)
leaf: 0x1001531 16782641 (33: nrow: 288 rrow: 288)
leaf: 0x1001532 16782642 (34: nrow: 288 rrow: 288)
leaf: 0x1001533 16782643 (35: nrow: 288 rrow: 288)
l