VIEW: SYS.DBA_EXTENTS

Source

View Text - Preformatted

select ds.owner, ds.segment_name, ds.partition_name, ds.segment_type,
       ds.tablespace_name,
       e.ext#, f.file#, e.block#, e.length * ds.blocksize, e.length, e.file#
from sys.uet$ e, sys.sys_dba_segs ds, sys.file$ f
where e.segfile# = ds.relative_fno
  and e.segblock# = ds.header_block
  and e.ts# = ds.tablespace_id
  and e.ts# = f.ts#
  and e.file# = f.relfile#
  and bitand(NVL(ds.segment_flags,0), 1) = 0
  and bitand(NVL(ds.segment_flags,0), 65536) = 0
union all
select
       ds.owner, ds.segment_name, ds.partition_name, ds.segment_type,
       ds.tablespace_name,
       e.ktfbueextno, f.file#, e.ktfbuebno,
       e.ktfbueblks * ds.blocksize, e.ktfbueblks, e.ktfbuefno
from sys.sys_dba_segs ds, sys.x$ktfbue e, sys.file$ f
where e.ktfbuesegfno = ds.relative_fno
  and e.ktfbuesegbno = ds.header_block
  and e.ktfbuesegtsn = ds.tablespace_id
  and ds.tablespace_id = f.ts#
  and e.ktfbuefno = f.relfile#
  and bitand(NVL(ds.segment_flags, 0), 1) = 1
  and bitand(NVL(ds.segment_flags,0), 65536) = 0

View Text - HTML Formatted

SELECT DS.OWNER
, DS.SEGMENT_NAME
, DS.PARTITION_NAME
, DS.SEGMENT_TYPE
, DS.TABLESPACE_NAME
, E.EXT#
, F.FILE#
, E.BLOCK#
, E.LENGTH * DS.BLOCKSIZE
, E.LENGTH
, E.FILE# FROM SYS.UET$ E
, SYS.SYS_DBA_SEGS DS
, SYS.FILE$ F WHERE E.SEGFILE# = DS.RELATIVE_FNO
AND E.SEGBLOCK# = DS.HEADER_BLOCK
AND E.TS# = DS.TABLESPACE_ID
AND E.TS# = F.TS#
AND E.FILE# = F.RELFILE#
AND BITAND(NVL(DS.SEGMENT_FLAGS
, 0)
, 1) = 0
AND BITAND(NVL(DS.SEGMENT_FLAGS
, 0)
, 65536) = 0 UNION ALL SELECT DS.OWNER
, DS.SEGMENT_NAME
, DS.PARTITION_NAME
, DS.SEGMENT_TYPE
, DS.TABLESPACE_NAME
, E.KTFBUEEXTNO
, F.FILE#
, E.KTFBUEBNO
, E.KTFBUEBLKS * DS.BLOCKSIZE
, E.KTFBUEBLKS
, E.KTFBUEFNO FROM SYS.SYS_DBA_SEGS DS
, SYS.X$KTFBUE E
, SYS.FILE$ F WHERE E.KTFBUESEGFNO = DS.RELATIVE_FNO
AND E.KTFBUESEGBNO = DS.HEADER_BLOCK
AND E.KTFBUESEGTSN = DS.TABLESPACE_ID
AND DS.TABLESPACE_ID = F.TS#
AND E.KTFBUEFNO = F.RELFILE#
AND BITAND(NVL(DS.SEGMENT_FLAGS
, 0)
, 1) = 1
AND BITAND(NVL(DS.SEGMENT_FLAGS
, 0)
, 65536) = 0