DBA Data[Home] [Help]

VIEW: SYS.KU$_EQNTABLE_BYTES_ALLOC_VIEW

Source

View Text - Preformatted

select tp.obj#,
            (select b.bytes_alloc from ku$_bytes_alloc_view b
             where b.ts_num = tp.ts#
               and b.file_num = tp.file#
               and b.block_num = tp.block#)
  from tab$ t, tabpart$ tp
  where t.obj#=tp.bo#
        and bitand(t.property, 32+8192+536870912)=536879136
View Text - HTML Formatted

SELECT TP.OBJ#
, (SELECT B.BYTES_ALLOC
FROM KU$_BYTES_ALLOC_VIEW B
WHERE B.TS_NUM = TP.TS#
AND B.FILE_NUM = TP.FILE#
AND B.BLOCK_NUM = TP.BLOCK#)
FROM TAB$ T
, TABPART$ TP
WHERE T.OBJ#=TP.BO#
AND BITAND(T.PROPERTY
, 32+8192+536870912)=536879136