VIEW: SYS.KU$_LOBFRAGINDEX_VIEW

Source

View Text - Preformatted

select i.obj#, value(o),
         ts.name, ts.blocksize,
         (select value(s) from ku$_storage_view s
          where i.file#  = s.file_num
          and   i.block# = s.block_num
          and   i.ts#    = s.ts_num),
         (select value(s) from ku$_deferred_stg_view s
          where s.obj_num = i.obj#),
         i.dataobj#, i.bo#,
         dbms_metadata.get_partn(4,i.bo#,i.part#), i.flags,
         i.pctfree$, i.pctthres$, i.initrans, i.maxtrans,
         to_char(i.analyzetime,'YYYY/MM/DD HH24:MI:SS'), i.samplesize, i.rowcnt,
         i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac,
         i.spare1, i.spare2, i.spare3, i.inclcol
   from  ku$_schemaobj_view o, indpart$ i, ts$ ts
   where o.obj_num = i.obj#
         AND  i.ts# = ts.ts#

View Text - HTML Formatted

SELECT I.OBJ#
, VALUE(O)
, TS.NAME
, TS.BLOCKSIZE
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE I.FILE# = S.FILE_NUM
AND I.BLOCK# = S.BLOCK_NUM
AND I.TS# = S.TS_NUM)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = I.OBJ#)
, I.DATAOBJ#
, I.BO#
, DBMS_METADATA.GET_PARTN(4
, I.BO#
, I.PART#)
, I.FLAGS
, I.PCTFREE$
, I.PCTTHRES$
, I.INITRANS
, I.MAXTRANS
, TO_CHAR(I.ANALYZETIME
, 'YYYY/MM/DD HH24:MI:SS')
, I.SAMPLESIZE
, I.ROWCNT
, I.BLEVEL
, I.LEAFCNT
, I.DISTKEY
, I.LBLKKEY
, I.DBLKKEY
, I.CLUFAC
, I.SPARE1
, I.SPARE2
, I.SPARE3
, I.INCLCOL
FROM KU$_SCHEMAOBJ_VIEW O
, INDPART$ I
, TS$ TS
WHERE O.OBJ_NUM = I.OBJ#
AND I.TS# = TS.TS#