转储索引结构:
SQL> select i.index_name,i.table_name,i.blevel from user_indexes i where i.index_name = 'IDX_T1_ID';
INDEX_NAME TABLE_NAME BLEVEL
------------------------------ ------------------------------ ----------
IDX_T1_ID T1 2
SQL> select object_id from dba_objects where object_name='IDX_T1_ID';
OBJECT_ID
----------
73821
SQL> alter session set events 'immediate trace name treedump level 73821';
会话已更改。
SQL>
SQL>
SQL> select d.value || '/' || lower(rtrim(i.instance, chr(0))) || '_ora_' ||
2 p.spid || '.trc' trace_file_name
3 from (select p.spid
4 from v$mystat m, v$session s, v$process p
5 where m.statistic# = 1
6 and s.sid = m.sid
7 and p.addr = s.paddr) p,
8 (select t.instance
9 from v$thread t, v$parameter v
10 where v.name = 'thread'
11 and (v.value = 0 or t.thread# = to_number(v.value))) i,
12 (select value from v$parameter where name = 'user_dump_dest') d;
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/u01/app/diag/rdbms/orcl/orcl/trace/orcl_ora_6255.trc
下面是trace文件:
----- begin tree dump
*** 2012-06-28 00:58:43.036
branch: 0x10001d3 16777683 (0: nrow: 9, level: 2) --nrow: 9 表示下面有9个branch;level: 2 表示Index的高度为3。
branch: 0x1009b56 16816982 (-1: nrow: 578, level: 1) --nrow: 578 表示有578个leaf。
leaf: 0x10001d4 16777684 (-1: nrow: 512 rrow: 221) --rrow: 221 表示每个叶子包含221行。
leaf: 0x10001d5 16777685 (0: nrow: 512 rrow: 221)
leaf: 0x10001d6 16777686 (1: nrow: 512 rrow: 221)
... ...
branch: 0x1009d79 16817529 (0: nrow: 538, level: 1)
leaf: 0x1009b55 16816981 (-1: nrow: 478 rrow: 224)
leaf: 0x1009b57 16816983 (0: nrow: 478 rrow: 223)
leaf: 0x1009b58 16816984 (1: nrow: 478 rrow: 222)
... ...
branch: 0x1009f9d 16818077 (1: nrow: 537, level: 1)
leaf: 0x1009d78 16817528 (-1: nrow: 448 rrow: 210)
leaf: 0x1009d7a 16817530 (0: nrow: 450 rrow: 210)
leaf: 0x1009d7b 16817531 (1: nrow: 448 rrow: 210)
... ...
branch: 0x100a1bf 16818623 (2: nrow: 537, level: 1)
leaf: 0x1009f9c 16818076 (-1: nrow: 448 rrow: 208)
leaf: 0x1009f9e 16818078 (0: nrow: 448 rrow: 208)
leaf: 0x1009f9f 16818079 (1: nrow: 448 rrow: 208)
... ...
branch: 0x100a3e4 16819172 (3: nrow: 540, level: 1)
leaf: 0x100a1be 16818622 (-1: nrow: 448 rrow: 209)
leaf: 0x100a1c0 16818624 (0: nrow: 448 rrow: 210)
leaf: 0x100a1c1 16818625 (1: nrow: 448 rrow: 210)
... ...
branch: 0x100a60a 16819722 (4: nrow: 539, level: 1)
leaf: 0x100a3e3 16819171 (-1: nrow: 450 rrow: 210)
leaf: 0x100a3e5 16819173 (0: nrow: 448 rrow: 210)
leaf: 0x100a3e6 16819174 (1: nrow: 448 rrow: 208)
... ...
branch: 0x100a82b 16820267 (5: nrow: 536, level: 1)
leaf: 0x100a609 16819721 (-1: nrow: 448 rrow: 208)
leaf: 0x100a60b 16819723 (0: nrow: 448 rrow: 209)
leaf: 0x100a60c 16819724 (1: nrow: 448 rrow: 210)
... ...
branch: 0x100aa4c 16820812 (6: nrow: 536, level: 1)
leaf: 0x100a82a 16820266 (-1: nrow: 448 rrow: 209)
leaf: 0x100a82c 16820268 (0: nrow: 448 rrow: 210)
leaf: 0x100a82d 16820269 (1: nrow: 449 rrow: 210)
... ...
branch: 0x100abfe 16821246 (7: nrow: 428, level: 1)
leaf: 0x100aa4b 16820811 (-1: nrow: 448 rrow: 210)
leaf: 0x100aa4d 16820813 (0: nrow: 448 rrow: 210)
leaf: 0x100aa4e 16820814 (1: nrow: 450 rrow: 210)
... ...
----- end tree dump