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. Its value is NULL.
segment_name	character varying(128)	Not supported. Its value is NULL.
partition_name	character varying(128)	Not supported. Its value is NULL.
segment_type	character varying(18)	Not supported. Its value is NULL.
segment_subtype	character varying(10)	Not supported. Its value is NULL.
tablespace_name	character varying(30)	Not supported. Its value is NULL.
header_file	numeric	Not supported. Its value is NULL.
header_block	numeric	Not supported. Its value is NULL.
bytes	numeric	Not supported. Its value is NULL.
blocks	numeric	Not supported. Its value is NULL.
extents	numeric	Not supported. Its value is NULL.
initial_extent	numeric	Not supported. Its value is NULL.
next_extent	numeric	Not supported. Its value is NULL.
min_extents	numeric	Not supported. Its value is NULL.
max_extents	numeric	Not supported. Its value is NULL.
max_size	numeric	Not supported. Its value is NULL.
retention	character varying(7)	Not supported. Its value is NULL.
minretention	numeric	Not supported. Its value is NULL.
pct_increase	numeric	Not supported. Its value is NULL.
freelists	numeric	Not supported. Its value is NULL.
freelist_groups	numeric	Not supported. Its value is NULL.
relative_fno	numeric	Not supported. Its value is NULL.
buffer_pool	character varying(7)	Not supported. Its value is NULL.
flash_cache	character varying(7)	Not supported. Its value is NULL.
cell_flash_cache	character varying(7)	Not supported. Its value is NULL.
inmemory	character varying(8)	Not supported. Its value is NULL.
inmemory_priority	character varying(8)	Not supported. Its value is NULL.
inmemory_distribute	character varying(15)	Not supported. Its value is NULL.
inmemory_duplicate	character varying(13)	Not supported. Its value is NULL.
inmemory_compression	character varying(17)	Not supported. Its value is NULL.
cellmemory	character varying(24)	Not supported. Its value is NULL.