VIEW: SYS.KU$_BYTES_ALLOC_VIEW

Source

View Text - Preformatted

select s.file_num,s.block_num,ts.ts#,
       case when ts.bitmapped=0
            then ts.blocksize*s.blocks
            else dbms_metadata_util.bytes_alloc(ts.ts#,
                                                s.file_num,
                                                s.block_num,
                                                ts.blocksize)
        end
  from ku$_storage_view s, ts$ ts
  where ts.ts#     = s.ts_num

View Text - HTML Formatted

SELECT S.FILE_NUM
, S.BLOCK_NUM
, TS.TS#
, CASE WHEN TS.BITMAPPED=0 THEN TS.BLOCKSIZE*S.BLOCKS ELSE DBMS_METADATA_UTIL.BYTES_ALLOC(TS.TS#
, S.FILE_NUM
, S.BLOCK_NUM
, TS.BLOCKSIZE) END
FROM KU$_STORAGE_VIEW S
, TS$ TS
WHERE TS.TS# = S.TS_NUM