Updated on 2024-05-07 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 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.