VIEW: SYS.TABSUBPARTV$

Source

View Text - Preformatted

select obj#, dataobj#, pobj#,
          row_number() over (partition by pobj# order by subpart#),
          flags, ts#, file#, block#, pctfree$,
          pctused$, initrans, maxtrans, analyzetime, samplesize, rowcnt,
          blkcnt, empcnt, avgspc, chncnt, avgrln, spare1, spare2, spare3,
          hiboundlen, hiboundval, subpart#
from tabsubpart$
where bitand(flags, 8388608) = 0          /* filter out hidden partitions */

View Text - HTML Formatted

SELECT OBJ#
, DATAOBJ#
, POBJ#
, ROW_NUMBER() OVER (PARTITION BY POBJ# ORDER BY SUBPART#)
, FLAGS
, TS#
, FILE#
, BLOCK#
, PCTFREE$
, PCTUSED$
, INITRANS
, MAXTRANS
, ANALYZETIME
, SAMPLESIZE
, ROWCNT
, BLKCNT
, EMPCNT
, AVGSPC
, CHNCNT
, AVGRLN
, SPARE1
, SPARE2
, SPARE3
, HIBOUNDLEN
, HIBOUNDVAL
, SUBPART# FROM TABSUBPART$ WHERE BITAND(FLAGS
, 8388608) = 0 /* FILTER OUT HIDDEN PARTITIONS */