MY_TAB_SUBPARTITIONS
MY_TAB_SUBPARTITIONS displays information about all level-2 partitioned tables accessible to the current user, including level-2 partition names, names of the tables and partitions to which the level-2 partitions belong, their storage attributes, and statistics generated by the DBMS_STATS package. This view can be accessed by all users. Only the information about the current user can be viewed. This view exists in both the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| table_owner | character varying(64) | Table owner. |
| schema | character varying(64) | Schema name. |
| table_name | character varying(64) | Table name. |
| partition_name | character varying(64) | Partition name. |
| subpartition_name | character varying(64) | Name of a level-2 partition. |
| high_value | text | Binding value expression in a level-2 partition. |
| high_value_length | integer | Length of the binding value expression in 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. |
| tablespace_name | name | Name of the tablespace where the level-2 partition is located. |
| pct_free | numeric | Percentage of minimum available space in a block. |
| pct_used | numeric | Not supported. Its value is NULL. |
| ini_trans | numeric | Initial number of transactions. |
| max_trans | numeric | Maximum number of transactions. |
| 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(7) | Specifies whether changes to a table are logged.
|
| compression | character varying(8) | Specifies whether a subpartition is compressed. Value range: ENABLED and DISABLED. |
| compress_for | character varying(30) | Not supported. Its value is NULL. |
| num_rows | numeric | Not supported. Its value is NULL. |
| 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 | Date when the table was last analyzed. Database restart is not supported. Otherwise, data loss will occur. |
| 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 in the interval section of an interval partitioned table (YES) or whether the partition is in the range section (NO). |
| segment_created | character varying(3) | Specifies whether the level-2 partition segment of the table has been created.
|
| indexing | character varying(3) | Not supported. Its value is NULL. |
| read_only | character varying(5) | 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. |
