VIEW: SYS.DBA_SEGMENTS_OLD

Source

View Text - Preformatted

select owner, segment_name, partition_name, segment_type, tablespace_name,
       header_file, header_block,
       dbms_space_admin.segment_number_blocks(tablespace_id, relative_fno,
       header_block, segment_type_id, buffer_pool_id, segment_flags,
       segment_objd, blocks)*blocksize,
       dbms_space_admin.segment_number_blocks(tablespace_id, relative_fno,
       header_block, segment_type_id, buffer_pool_id, segment_flags,
       segment_objd, blocks),
       dbms_space_admin.segment_number_extents(tablespace_id, relative_fno,
       header_block, segment_type_id, buffer_pool_id, segment_flags,
       segment_objd, extents),
       initial_extent, next_extent, min_extents, max_extents, pct_increase,
       freelists, freelist_groups, relative_fno,
       decode(buffer_pool_id, 1, 'KEEP', 2, 'RECYCLE', 'DEFAULT')
from sys_dba_segs

View Text - HTML Formatted

SELECT OWNER
, SEGMENT_NAME
, PARTITION_NAME
, SEGMENT_TYPE
, TABLESPACE_NAME
, HEADER_FILE
, HEADER_BLOCK
, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(TABLESPACE_ID
, RELATIVE_FNO
, HEADER_BLOCK
, SEGMENT_TYPE_ID
, BUFFER_POOL_ID
, SEGMENT_FLAGS
, SEGMENT_OBJD
, BLOCKS)*BLOCKSIZE
, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(TABLESPACE_ID
, RELATIVE_FNO
, HEADER_BLOCK
, SEGMENT_TYPE_ID
, BUFFER_POOL_ID
, SEGMENT_FLAGS
, SEGMENT_OBJD
, BLOCKS)
, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_EXTENTS(TABLESPACE_ID
, RELATIVE_FNO
, HEADER_BLOCK
, SEGMENT_TYPE_ID
, BUFFER_POOL_ID
, SEGMENT_FLAGS
, SEGMENT_OBJD
, EXTENTS)
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENTS
, MAX_EXTENTS
, PCT_INCREASE
, FREELISTS
, FREELIST_GROUPS
, RELATIVE_FNO
, DECODE(BUFFER_POOL_ID
, 1
, 'KEEP'
, 2
, 'RECYCLE'
, 'DEFAULT') FROM SYS_DBA_SEGS