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.
| Name | Type | Description |
|---|---|---|
| owner | character varying(128) | Not supported. Set it to NULL. |
| segment_name | character varying(128) | Not supported. Set it to NULL. |
| partition_name | character varying(128) | Not supported. Set it to NULL. |
| segment_type | character varying(18) | Not supported. Set it to NULL. |
| segment_subtype | character varying(10) | Not supported. Set it to NULL. |
| tablespace_name | character varying(30) | Not supported. Set it to NULL. |
| header_file | numeric | Not supported. Set it to NULL. |
| header_block | numeric | Not supported. Set it to NULL. |
| bytes | numeric | Not supported. Set it to NULL. |
| blocks | numeric | Not supported. Set it to NULL. |
| extents | numeric | Not supported. Set it to NULL. |
| initial_extent | numeric | Not supported. Set it to NULL. |
| next_extent | numeric | Not supported. Set it to NULL. |
| min_extents | numeric | Not supported. Set it to NULL. |
| max_extents | numeric | Not supported. Set it to NULL. |
| max_size | numeric | Not supported. Set it to NULL. |
| retention | character varying(7) | Not supported. Set it to NULL. |
| minretention | numeric | Not supported. Set it to NULL. |
| pct_increase | numeric | Not supported. Set it to NULL. |
| freelists | numeric | Not supported. Set it to NULL. |
| freelist_groups | numeric | Not supported. Set it to NULL. |
| relative_fno | numeric | Not supported. Set it to NULL. |
| buffer_pool | character varying(7) | Not supported. Set it to NULL. |
| flash_cache | character varying(7) | Not supported. Set it to NULL. |
| cell_flash_cache | character varying(7) | Not supported. Set it to NULL. |
| inmemory | character varying(8) | Not supported. Set it to NULL. |
| inmemory_priority | character varying(8) | Not supported. Set it to NULL. |
| inmemory_distribute | character varying(15) | Not supported. Set it to NULL. |
| inmemory_duplicate | character varying(13) | Not supported. Set it to NULL. |
| inmemory_compression | character varying(17) | Not supported. Set it to NULL. |
| cellmemory | character varying(24) | Not supported. Set it to NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
