VIEW: SYS.LOBFRAGV$

Source

View Text - Preformatted

select fragobj#, parentobj#, tabfragobj#, indfragobj#,
          row_number() over (partition by parentobj# order by frag#),
          fragtype$, ts#, file#, block#, chunk, pctversion$, fragflags,
          fragpro, spare1, spare2, spare3
from lobfrag$
where bitand(fragflags, 67108864) = 0        /* filter out hidden fragments */

View Text - HTML Formatted

SELECT FRAGOBJ#
, PARENTOBJ#
, TABFRAGOBJ#
, INDFRAGOBJ#
, ROW_NUMBER() OVER (PARTITION BY PARENTOBJ# ORDER BY FRAG#)
, FRAGTYPE$
, TS#
, FILE#
, BLOCK#
, CHUNK
, PCTVERSION$
, FRAGFLAGS
, FRAGPRO
, SPARE1
, SPARE2
, SPARE3 FROM LOBFRAG$ WHERE BITAND(FRAGFLAGS
, 67108864) = 0 /* FILTER OUT HIDDEN FRAGMENTS */