heap表和iot表排序规则不同

heap 和iot 对比

OBJECT_NAME															 OBJECT_TYPE
-------------------------------------------------------------------------------------------------------------------------------- -------------------
T2																 TABLE
SYS_C0022204															 INDEX
T1																 TABLE
SYS_IOT_TOP_102688														 INDEX

OBJECT_NAME															  OBJECT_ID
-------------------------------------------------------------------------------------------------------------------------------- ----------
T2																     102688
SYS_C0022204															     102687
T1																     102686
SYS_IOT_TOP_102688														     102689

 select value from v$diag_info where name='Default Trace File';
alter session set events 'immediate trace name treedump level 102687';



----- begin tree dump
branch: 0x10000c3 16777411 (0: nrow: 5, level: 1)
   leaf: 0x10000c6 16777414 (-1: nrow: 193 rrow: 193)
   leaf: 0x10000c7 16777415 (0: nro