1
　　14          3
　　15          2
　　16          2
　　17          3
　　18          2
　　19          1
　　20          3
　　SQL> connect hr/hr
　　已连接。
　　SQL> alter session set events '10608 trace name context forever, level 10';
　　会话已更改。
　　SQL> create bitmap index idx_t_bitmap_test on t_bitmap_test(bitcol);
　　索引已创建。
　　SQL> alter session set events '10608 trace name context off';
　　会话已更改。
　　SQL> select object_id from user_objects where object_name='IDX_T_BITMAP_TEST';
　　OBJECT_ID
　　----------
　　24499
　　SQL> alter session set events 'immediate trace name TREEDUMP level 24499';
　　会话已更改。
　　10608事件用来跟踪创建bitmap索引的过程。而TREEDUMP则用来转储索引的树状结构。打开转储出来的文件：
　　*** SESSION ID:(7.13) 2008-06-10 14:33:46.000
　　qerbiARwo: bitmap size is 8168
　　qerbiIPI default pctfree=10
　　qerbiIPI length=0
　　qerbiAllocate pfree=127 space=8168
　　qerbiStart first start
　　qerbiRop: rid=00c01ce4.0000, new=Y , key: (2): c1 04
　　qerbiCmpSz notfound pctfree=10
　　qerbiCmpSz adjblksize=7351 length=0
　　qerbiRop keysize=4 maxbm=3531
　　kdibcoinit(3116714): srid=00c01ce4.0000
　　qerbiRop: rid=00c01ce4.0001, new=Y , key: (2): c1 03
　　kdibcoinit(3116698): srid=00c01ce4.0001
　　qerbiRop: rid=00c01ce4.0002, new=Y , key: (2): c1 02
　　kdibcoinit(311661c): srid=00c01ce4.0002
　　qerbiRop: rid=00c01ce4.0003, new=N, key: (2): c1 04
　　qerbiRop: rid=00c01ce4.0004, new=N, key: (2): c1 04
　　qerbiRop: rid=00c01ce4.0005, new=N, key: (2): c1 02
　　qerbiRop: rid=00c01ce4.0006, new=N, key: (2): c1 02
　　qerbiRop: rid=00c01ce4.0007, new=N, key: (2): c1 03
　　qerbiRop: rid=00c01ce4.0008, new=N, key: (2): c1 04
　　qerbiRop: rid=00c01ce4.0009, new=N, key: (2): c1 03
　　qerbiRop: rid=00c01ce4.000a, new=N, key: (2): c1 04
　　qerbiRop: rid=00c01ce4.000b, new=N, key: (2): c1 02
　　qerbiRop: rid=00c01ce4.000c, new=N, key: (2): c1 02
　　qerbiRop: rid=00c01ce4.000d, new=N, key: (2): c1 04
　　qerbiRop: rid=00c01ce4.000e, new=N, key: (2): c1 03
　　qerbiRop: rid=00c01ce4.000f, new=N, key: (2): c1 03
　　qerbiRop: rid=00c01ce4.0010, new=N, key: (2): c1 04
　　qerbiRop: rid=00c01ce4.0011, new=N, key: (2): c1 03
　　qerbiRop: rid=00c01ce4.0012, new=N, key: (2): c1 02
　　qerbiRop: rid=00c01ce4.0013, new=N, key: (2): c1 04
　　kdibcoend(3116714): erid=00c01ce4.0017status=3
　　
　　　qerbiCon: key: (2): c1 04
　　srid=00c01ce4.0 erid=00c01ce4.17 bitmap: (4): ca 19 25 09