SQL> INSERT INTO TEST_LEAF VALUES(2,'TEST'||TO_CHAR(2));

1 row created.

SQL> COMMIT;

Commit complete.

SQL> ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME TREEDUMP LEVEL 70389';

Session altered.


*** 2009-02-12 08:24:11.439
KGX cleanup...
KGX Atomic Operation Log 0x2b5b83b4
 Mutex 0x29aa2d08(170, 0) idn 2fde77c3 oper EXAM
 Cursor Parent uid 170 efd 5 whr 26 slp 0
 oper=OPERATION_DEFAULT pt1=(nil) pt2=(nil) pt3=(nil)
 pt4=(nil) u41=0 stt=0

*** 2009-02-12 08:24:22.570
----- begin tree dump
branch: 0x100d285 16831109 (0: nrow: 83, level: 1)
   leaf: 0x100d293 16831123 (-1: nrow: 71 rrow: 71)
   leaf: 0x100d31e 16831262 (0: nrow: 60 rrow: 60)
   leaf: 0x100d28d 16831117 (1: nrow: 123 rrow: 123)
   leaf: 0x100d28e 16831118 (2: nrow: 123 rrow: 123)
   leaf: 0x100d28f 16831119 (3: nrow: 123 rrow: 123)
   leaf: 0x100d290 16831120 (4: nrow: 123 rrow: 123)
   leaf: 0x100d286 16831110 (5: nrow: 123 rrow: 123)
   leaf: 0x100d287 16831111 (6: nrow: 123 rrow: 123)
   leaf: 0x100d288 16831112 (7: nrow: 123 rrow: 123)
   leaf: 0x100d289 16831113 (8: nrow: 123 rrow: 123)
   leaf: 0x100d28b 16831115 (9: nrow: 123 rrow: 123)
   leaf: 0x100d28c 16831116 (10: nrow: 123 rrow: 123)
   leaf: 0x100d28a 16831114 (11: nrow: 123 rrow: 123)
   leaf: 0x100d294 16831124 (12: nrow: 123 rrow: 123)
   leaf: 0x100d295 16831125 (13: nrow: 123 rrow: 123)
   leaf: 0x100d296 16831126 (14: nrow: 123 rrow: 123)
   leaf: 0x100d297 16831127 (15: nrow: 123 rrow: 123)
   leaf: 0x100d298 16831128 (16: nrow: 123 rrow: 123)
   leaf: 0x100d299 16831129 (17: nrow: 123 rrow: 123)
   leaf: 0x100d29a 16831130 (18: nrow: 123 rrow: 123)
   leaf: 0x100d29b 16831131 (19: nrow: 123 rrow: 123)
   leaf: 0x100d29c 16831132 (20: nrow: 123 rrow: 123)
   leaf: 0x100d29d 16831133 (21: nrow: 123 rrow: 123)
   leaf: 0x100d29e 16831134 (22: nrow: 123 rrow: 123)
   leaf: 0x100d29f 16831135 (23: nrow: 123 rrow: 123)
   leaf: 0x100d2a0 16831136 (24: nrow: 123 rrow: 123)
   leaf: 0x100d291 16831121 (25: nrow: 123 rrow: 123)
   leaf: 0x100d292 16831122 (26: nrow: 123 rrow: 123)
   leaf: 0x100d2d3 16831187 (27: nrow: 123 rrow: 123)
   leaf: 0x100d2c7 16831175 (28: nrow: 123 rrow: 123)
   leaf: 0x100d2c8 16831176 (29: nrow: 123 rrow: 123)
   leaf: 0x100d2c9 16831177 (30: nrow: 123 rrow: 123)
   leaf: 0x100d2ca 16831178 (31: nrow: 123 rrow: 123)
   leaf: 0x100d2cb 16831179 (32: nrow: 123 rrow: 123)
   leaf: 0x100d2cc 16831180 (33: nrow: 123 rrow: 123)
   leaf: 0x100d2cd 16831181 (34: nrow: 123 rrow: 123)
   leaf: 0x100d2ce 16831182 (35: nrow: 123 rrow: 123)
   leaf: 0x100d2cf 16831183 (36: nrow: 123 rrow: 123)
   leaf: 0x100d2d0 16831184 (37: nrow: 123 rrow: 123)
   leaf: 0x100d2c3 16831171 (38: nrow: 123 rrow: 123)
   leaf: 0x100d2c4 16831172 (39: nrow: 123 rrow: 123)
   leaf: 0x100d2c5 16831173 (40: nrow: 123 rrow: 123)
   leaf: 0x100d2c6 16831174 (41: nrow: 123 rrow: 123)
   leaf: 0x100d2d4 16831188 (42: nrow: 123 rrow: 123)
   leaf: 0x100d2d5 16831189 (43: nrow: 123 rrow: 123)
   leaf: 0x100d2d6 16831190 (44: nrow: 123 rrow: 123)
   leaf: 0x100d2d7 16831191 (45: nrow: 123 rrow: 123)
   leaf: 0x100d2d8 16831192 (46: nrow: 123 rrow: 123)
   leaf: 0x100d2d9 16831193 (47: nrow: 123 rrow: 123)
   leaf: 0x100d2da 16831194 (48: nrow: 123 rrow: 123)
   leaf: 0x100d2db 16831195 (49: nrow: 123 rrow: 123)
   leaf: 0x100d2dc 16831196 (50: nrow: 123 rrow: 123)
   leaf: 0x100d2dd 16831197 (51: nrow: 123 rrow: 123)
   leaf: 0x100d2de 16831198 (52: nrow: 123 rrow: 123)
   leaf: 0x100d2df 16831199 (53: nrow: 123 rrow: 123)
   leaf: 0x100d2e0 16831200 (54: nrow: 123 rrow: 123)
   leaf: 0x100d2d1 16831185 (55: nrow: 123 rrow: 123)
   leaf: 0x100d2d2 16831186 (56: nrow: 123 rrow: 123)
   leaf: 0x100d313 16831251 (57: nrow: 123 rrow: 123)
   leaf: 0x100d307 16831239 (58: nrow: 123 rrow: 123)
   leaf: 0x100d308 16831240 (59: nrow: 123 rrow: 123)
   leaf: 0x100d309 16831241 (60: nrow: 123 rrow: 123)
   leaf: 0x100d30a 16831242 (61: nrow: 123 rrow: 123)
   leaf: 0x100d30b 16831243 (62: nrow: 123 rrow: 123)
   leaf: 0x100d30c 16831244 (63: nrow: 123 rrow: 123)
   leaf: 0x100d30d 16831245 (64: nrow: 123 rrow: 123)
   leaf: 0x100d30e 16831246 (65: nrow: 123 rrow: 123)
   leaf: 0x100d30f 16831247 (66: nrow: 123 rrow: 123)
   leaf: 0x100d310 16831248 (67: nrow: 123 rrow: 123)
   leaf: 0x100d303 16831235 (68: nrow: 123 rrow: 123)
   leaf: 0x100d304 16831236 (69: nrow: 123 rrow: 123)
   leaf: 0x100d305 16831237 (70: nrow: 123 rrow: 123)
   leaf: 0x100d306 16831238 (71: nrow: 123 rrow: 123)
   leaf: 0x100d314 16831252 (72: nrow: 123 rrow: 123)
   leaf: 0x100d315 16831253 (73: nrow: 123 rrow: 123)
   leaf: 0x100d316 16831254 (74: nrow: 123 rrow: 123)
   leaf: 0x100d317 16831255 (75: nrow: 123 rrow: 123)
   leaf: 0x100d318 16831256 (76: nrow: 123 rrow: 123)
   leaf: 0x100d319 16831257 (77: nrow: 123 rrow: 123)
   leaf: 0x100d31a 16831258 (78: nrow: 123 rrow: 123)
   leaf: 0x100d31b 16831259 (79: nrow: 123 rrow: 123)
   leaf: 0x100d31c 16831260 (80: nrow: 123 rrow: 123)
   leaf: 0x100d31d 16831261 (81: nrow: 30 rrow: 30)
----- end tree dump