select t.obj#,
(select b.bytes_alloc from ku$_bytes_alloc_view b
where b.ts_num = i.ts#
and b.file_num = i.file#
and b.block_num = i.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
where b.ts_num = l.ts#
and b.file_num = l.file#
and b.block_num = l.block#
and l.obj#=t.obj#))
from ind$ i, tab$ t
where t.pctused$ = i.obj# -- For IOTs, pctused has index obj#
SELECT T.OBJ#
,
(SELECT B.BYTES_ALLOC
FROM KU$_BYTES_ALLOC_VIEW B
WHERE B.TS_NUM = I.TS#
AND B.FILE_NUM = I.FILE#
AND B.BLOCK_NUM = I.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
WHERE B.TS_NUM = L.TS#
AND B.FILE_NUM = L.FILE#
AND B.BLOCK_NUM = L.BLOCK#
AND L.OBJ#=T.OBJ#))
FROM IND$ I
, TAB$ T
WHERE T.PCTUSED$ = I.OBJ# -- FOR IOTS
, PCTUSED HAS INDEX OBJ#
|
|
|