Well you could ask them what the following hexa values stand for in the trace files
Code:/* 0x01 = typed table, 0x02 = has ADT columns, */ /* 0x04 = has nested-TABLE columns, 0x08 = has REF columns, */ /* 0x10 = has array columns, 0x20 = partitioned table, */ /* 0x40 = index-only table (IOT), 0x80 = IOT w/ row OVerflow, */ /* 0x100 = IOT w/ row CLustering, 0x200 = IOT OVeRflow segment, */ /* 0x400 = clustered table, 0x800 = has internal LOB columns, */ /* 0x1000 = has primary key-based OID$ column, 0x2000 = nested table */ /* 0x4000 = View is Read Only, 0x8000 = has FILE columns */ /* 0x10000 = obj view's OID is system-gen, 0x20000 = used as AQ table */ /* 0x40000 = has user-defined lob columns */ /* 0x00080000 = table contains unused columns */ /* 0x100000 = has an on-commit materialized view */ /* 0x200000 = has system-generated column names */ /* 0x00400000 = global temporary table */ /* 0x00800000 = session-specific temporary table */ /* 0x08000000 = table is a sub table */ /* 0x20000000 = pdml itl invariant */ /* 0x80000000 = table is external */ /* 0x00000001 = deferred RPC Queue */ /* 0x00000002 = snapshot log */ /* 0x00000004 = updatable snapshot log */ /* 0x00000008 = context trigger */ /* 0x00000010 = synchronous change table */ /* 0x00200000 = table had rowmovement */







Reply With Quote