Updated on 2024-05-07 GMT+08:00

DB_TAB_SUBPARTITIONS

DB_TAB_SUBPARTITIONS displays information about level-2 partitioned tables accessible to the current user. It is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_TAB_SUBPARTITIONS columns

Name

Type

Description

table_owner

character varying(64)

Table owner.

table_name

character varying(64)

Relational table name.

partition_name

character varying(64)

Partition name.

subpartition_name

character varying(64)

Name of a level-2 partition.

high_value

text

Limit of a level-2 partition.

  • For range partitioning and interval partitioning, the upper limit of each partition is displayed.
  • For list partitioning, the value list of each partition is displayed.
  • For hash partitioning, the number of each partition is displayed.

tablespace_name

name

Tablespace name of a level-2 partitioned table.

schema

character varying(64)

Name of a namespace.

high_value_length

integer

Character length of the limit of a level-2 partition.

partition_position

numeric

Position of the partition in the table.

subpartition_position

numeric

Position of the level-2 partition in the partition.

pct_free

numeric

Minimum percentage of available space in a block.

pct_used

numeric

Not supported. Its value is NULL.

ini_trans

numeric

Initial number of transactions. The default value is 4. The value is NULL for non-Ustore partitioned tables.

max_trans

numeric

Maximum number of transactions. The default value is 128. The value is NULL for non-Ustore partitioned tables.

initial_extent

numeric

Not supported. Its value is NULL.

next_extent

numeric

Not supported. Its value is NULL.

min_extent

numeric

Not supported. Its value is NULL.

max_extent

numeric

Not supported. Its value is NULL.

max_size

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.

logging

character varying(3)

Specifies whether changes to a table are logged.

compression

character varying(8)

Actual compression attribute of a partitioned table.

compress_for

character varying(30)

Not supported. Its value is NULL.

num_rows

numeric

Number of rows in a level-2 partition.

blocks

numeric

Not supported. Its value is NULL.

empty_blocks

numeric

Not supported. Its value is NULL.

avg_space

numeric

Not supported. Its value is NULL.

chain_cnt

numeric

Not supported. Its value is NULL.

avg_row_len

numeric

Not supported. Its value is NULL.

sample_size

numeric

Not supported. Its value is NULL.

last_analyzed

timestamp with time zone

Last date when the partition was analyzed.

buffer_pool

character varying(7)

Buffer pool of a level-2 partition.

flash_cache

character varying(7)

Not supported. Its value is NULL.

cell_flash_cache

character varying(7)

Not supported. Its value is NULL.

global_stats

character varying(3)

Not supported. Its value is NULL.

user_stats

character varying(3)

Not supported. Its value is NULL.

interval

character varying(3)

Specifies whether the partition is a partition in an interval partitioned table.

segment_created

character varying(3)

Specifies whether a segment is created in a level-2 partitioned table.

indexing

character varying(3)

Not supported. Its value is NULL.

read_only

character varying(3)

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_compression

character varying(17)

Not supported. Its value is NULL.

inmemory_duplicate

character varying(13)

Not supported. Its value is NULL.

inmemory_service

character varying(12)

Not supported. Its value is NULL.

inmemory_service_name

character varying(1000)

Not supported. Its value is NULL.

cellmemory

character varying(24)

Not supported. Its value is NULL.

memoptimize_read

character varying(8)

Not supported. Its value is NULL.

memoptimize_write

character varying(8)

Not supported. Its value is NULL.