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 Astore engine supports the segment-page storage, but information cannot be obtained from the system catalog.

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