VIEW: SYS.KU$_HTSPART_BYTES_ALLOC_VIEW

Source

View Text - Preformatted

select tsp.obj#,
            (select b.bytes_alloc from ku$_bytes_alloc_view b
             where b.ts_num = tsp.ts#
               and b.file_num = tsp.file#
               and b.block_num = tsp.block#)
          +decode(bitand(t.property,2048+262144),0,0,   -- add lob storage
            (select sum(b.bytes_alloc) from ku$_bytes_alloc_view b, lobfrag$ l
             where b.ts_num = l.ts#
               and b.file_num = l.file#
               and b.block_num = l.block#
               and l.tabfragobj#=tsp.obj#))
  from tab$ t, tabcompart$ tcp, tabsubpart$ tsp
  where t.obj#=tcp.bo#
    AND tcp.obj# = tsp.pobj#

View Text - HTML Formatted

SELECT TSP.OBJ#
, (SELECT B.BYTES_ALLOC
FROM KU$_BYTES_ALLOC_VIEW B
WHERE B.TS_NUM = TSP.TS#
AND B.FILE_NUM = TSP.FILE#
AND B.BLOCK_NUM = TSP.BLOCK#) +DECODE(BITAND(T.PROPERTY
, 2048+262144)
, 0
, 0
, -- ADD LOB STORAGE (SELECT SUM(B.BYTES_ALLOC)
FROM KU$_BYTES_ALLOC_VIEW B
, LOBFRAG$ L
WHERE B.TS_NUM = L.TS#
AND B.FILE_NUM = L.FILE#
AND B.BLOCK_NUM = L.BLOCK#
AND L.TABFRAGOBJ#=TSP.OBJ#))
FROM TAB$ T
, TABCOMPART$ TCP
, TABSUBPART$ TSP
WHERE T.OBJ#=TCP.BO#
AND TCP.OBJ# = TSP.POBJ#