VIEW: SYS.KU$_HNTP_VIEW

Source

View Text - Preformatted

select tp.obj#, t.property,
        (select value(s) from ku$_storage_view s
         where     tp.file#  = s.file_num
             and   tp.block# = s.block_num
             and   tp.ts#    = s.ts_num),
        (select value(s) from ku$_deferred_stg_view s
         where s.obj_num = tp.obj#),
        (select ts.name from ts$ ts where tp.ts# = ts.ts#),
        (select ts.blocksize from ts$ ts where tp.ts# = ts.ts#),
        tp.pctfree$, tp.pctused$, tp.initrans, tp.maxtrans, tp.flags
  from tabpart$ tp, tab$ t
  where tp.bo# = t.obj# and
        bitand(t.property,64+512) = 0 -- skip IOT and overflow segs

View Text - HTML Formatted

SELECT TP.OBJ#
, T.PROPERTY
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE TP.FILE# = S.FILE_NUM
AND TP.BLOCK# = S.BLOCK_NUM
AND TP.TS# = S.TS_NUM)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = TP.OBJ#)
, (SELECT TS.NAME
FROM TS$ TS
WHERE TP.TS# = TS.TS#)
, (SELECT TS.BLOCKSIZE
FROM TS$ TS
WHERE TP.TS# = TS.TS#)
, TP.PCTFREE$
, TP.PCTUSED$
, TP.INITRANS
, TP.MAXTRANS
, TP.FLAGS
FROM TABPART$ TP
, TAB$ T
WHERE TP.BO# = T.OBJ# AND BITAND(T.PROPERTY
, 64+512) = 0 -- SKIP IOT
AND OVERFLOW SEGS