Updated on 2024-06-03 GMT+08:00

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.