select t.obj#, t.dataobj#, t.bobj#,
(select value(s) from ku$_storage_view s
where t.file# = s.file_num
and t.block# = s.block_num
and t.ts# = s.ts_num),
(select value(s) from ku$_deferred_stg_view s
where s.obj_num = t.obj#),
ts.name, ts.blocksize,
t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.flags
from tab$ t, ts$ ts
where bitand(t.property,512) = 512
and t.ts# = ts.ts#
SELECT T.OBJ#
, T.DATAOBJ#
, T.BOBJ#
,
(SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE T.FILE# = S.FILE_NUM
AND T.BLOCK# = S.BLOCK_NUM
AND T.TS# = S.TS_NUM)
,
(SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = T.OBJ#)
,
TS.NAME
, TS.BLOCKSIZE
,
T.PCTFREE$
, T.PCTUSED$
, T.INITRANS
, T.MAXTRANS
, T.FLAGS
FROM TAB$ T
, TS$ TS
WHERE BITAND(T.PROPERTY
, 512) = 512
AND T.TS# = TS.TS#
|
|
|