VIEW: SYS.KU$_IOTPART_BYTES_ALLOC_VIEW

Source

View Text - Preformatted

select ip.obj#,
            (select b.bytes_alloc from ku$_bytes_alloc_view b
             where b.ts_num = ip.ts#
               and b.file_num = ip.file#
               and b.block_num = ip.block#)
          +decode(bitand(t.property,2048+262144),0,0,   -- add lob storage
            (select sum(b.bytes_alloc)
             from ku$_bytes_alloc_view b, lob$ l,lobfrag$ lf
             where lf.frag#=ip.part#
               and t.obj#=l.obj# and l.lobj#=lf.parentobj#
               and b.ts_num = lf.ts#
               and b.file_num = lf.file#
               and b.block_num = lf.block#))
  from ind$ i, indpart$ ip, tab$ t
  where i.bo#=t.obj#
    and ip.bo#=i.obj#
    and i.type#=4           -- iot index

View Text - HTML Formatted

SELECT IP.OBJ#
, (SELECT B.BYTES_ALLOC
FROM KU$_BYTES_ALLOC_VIEW B
WHERE B.TS_NUM = IP.TS#
AND B.FILE_NUM = IP.FILE#
AND B.BLOCK_NUM = IP.BLOCK#) +DECODE(BITAND(T.PROPERTY
, 2048+262144)
, 0
, 0
, -- ADD LOB STORAGE (SELECT SUM(B.BYTES_ALLOC)
FROM KU$_BYTES_ALLOC_VIEW B
, LOB$ L
, LOBFRAG$ LF
WHERE LF.FRAG#=IP.PART#
AND T.OBJ#=L.OBJ#
AND L.LOBJ#=LF.PARENTOBJ#
AND B.TS_NUM = LF.TS#
AND B.FILE_NUM = LF.FILE#
AND B.BLOCK_NUM = LF.BLOCK#))
FROM IND$ I
, INDPART$ IP
, TAB$ T
WHERE I.BO#=T.OBJ#
AND IP.BO#=I.OBJ#
AND I.TYPE#=4 -- IOT INDEX