ADM_SEGMENTS

ADM_SEGMENTS displays the storage space allocated to all segments in the database. It exists in the PG_CATALOG and SYS schemas. Only the system administrator can access this view. The information cannot be obtained from the system catalog. The view is empty.

**Table 1** ADM_SEGMENTS columns
Name	Type	Description
owner	character varying(128)	Not supported. Set it to NULL.
segment_name	character varying(128)	Not supported. Set it to NULL.
partition_name	character varying(128)	Not supported. Set it to NULL.
segment_type	character varying(18)	Not supported. Set it to NULL.
segment_subtype	character varying(10)	Not supported. Set it to NULL.
tablespace_name	character varying(30)	Not supported. Set it to NULL.
header_file	numeric	Not supported. Set it to NULL.
header_block	numeric	Not supported. Set it to NULL.
bytes	numeric	Not supported. Set it to NULL.
blocks	numeric	Not supported. Set it to NULL.
extents	numeric	Not supported. Set it to NULL.
initial_extent	numeric	Not supported. Set it to NULL.
next_extent	numeric	Not supported. Set it to NULL.
min_extents	numeric	Not supported. Set it to NULL.
max_extents	numeric	Not supported. Set it to NULL.
max_size	numeric	Not supported. Set it to NULL.
retention	character varying(7)	Not supported. Set it to NULL.
minretention	numeric	Not supported. Set it to NULL.
pct_increase	numeric	Not supported. Set it to NULL.
freelists	numeric	Not supported. Set it to NULL.
freelist_groups	numeric	Not supported. Set it to NULL.
relative_fno	numeric	Not supported. Set it to NULL.
buffer_pool	character varying(7)	Not supported. Set it to NULL.
flash_cache	character varying(7)	Not supported. Set it to NULL.
cell_flash_cache	character varying(7)	Not supported. Set it to NULL.
inmemory	character varying(8)	Not supported. Set it to NULL.
inmemory_priority	character varying(8)	Not supported. Set it to NULL.
inmemory_distribute	character varying(15)	Not supported. Set it to NULL.
inmemory_duplicate	character varying(13)	Not supported. Set it to NULL.
inmemory_compression	character varying(17)	Not supported. Set it to NULL.
cellmemory	character varying(24)	Not supported. Set it to NULL.