[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | USER_SEGMENTS |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
Storage allocated for all database segments
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SEGMENT_NAME | VARCHAR2 | (128) | Name, if any, of the segment | |
| PARTITION_NAME | VARCHAR2 | (128) | Partition/Subpartition Name, if any, of the segment | |
| SEGMENT_TYPE | VARCHAR2 | (18) | Type of segment: "TABLE", "CLUSTER", "INDEX", "ROLLBACK", "DEFERRED ROLLBACK", "TEMPORARY", "SPACE HEADER", "TYPE2 UNDO" or "CACHE" | |
| SEGMENT_SUBTYPE | VARCHAR2 | (10) | SubType of Lob segment: "SECUREFILE", "ASSM", "MSSM", NULL | |
| TABLESPACE_NAME | VARCHAR2 | (30) | Name of the tablespace containing the segment | |
| BYTES | NUMBER | Size, in bytes, of the segment | ||
| BLOCKS | NUMBER | Size, in Oracle blocks, of the segment | ||
| EXTENTS | NUMBER | Number of extents allocated to the segment | ||
| INITIAL_EXTENT | NUMBER | Size, in bytes, of the initial extent of the segment | ||
| NEXT_EXTENT | NUMBER | Size, in bytes, of the next extent to be allocated to the segment | ||
| MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment | ||
| MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment | ||
| MAX_SIZE | NUMBER | Maximum number of blocks allowed in the segment | ||
| RETENTION | VARCHAR2 | (7) | Retention option for SECUREFILE segment | |
| MINRETENTION | NUMBER | Minimum Retention Duration for SECUREFILE segment | ||
| PCT_INCREASE | NUMBER | Percent by which to increase the size of the next extent to be allocated | ||
| FREELISTS | NUMBER | Number of process freelists allocated to this segment | ||
| FREELIST_GROUPS | NUMBER | Number of freelist groups allocated to this segment | ||
| BUFFER_POOL | VARCHAR2 | (7) | The default buffer pool to be used for blocks from this segment | |
| FLASH_CACHE | VARCHAR2 | (7) | ||
| CELL_FLASH_CACHE | VARCHAR2 | (7) | ||
| INMEMORY | VARCHAR2 | (8) | Whether in-memory is enabled or not | |
| INMEMORY_PRIORITY | VARCHAR2 | (8) | User defined priority in which in-memory column store object is loaded | |
| INMEMORY_DISTRIBUTE | VARCHAR2 | (15) | How the in-memory columnar store object is distributed | |
| INMEMORY_DUPLICATE | VARCHAR2 | (13) | How the in-memory column store object is duplicated | |
| INMEMORY_COMPRESSION | VARCHAR2 | (17) | Compression level for the in-memory column store option |
Cut, paste (and edit) the following text to query this object:
SELECT SEGMENT_NAME
, PARTITION_NAME
, SEGMENT_TYPE
, SEGMENT_SUBTYPE
, TABLESPACE_NAME
, BYTES
, BLOCKS
, EXTENTS
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENTS
, MAX_EXTENTS
, MAX_SIZE
, RETENTION
, MINRETENTION
, PCT_INCREASE
, FREELISTS
, FREELIST_GROUPS
, BUFFER_POOL
, FLASH_CACHE
, CELL_FLASH_CACHE
, INMEMORY
, INMEMORY_PRIORITY
, INMEMORY_DISTRIBUTE
, INMEMORY_DUPLICATE
, INMEMORY_COMPRESSION
FROM SYS.USER_SEGMENTS;
SYS
DBMS_SPACE_ADMIN
- show dependent code
SYS_USER_SEGS
PUBLIC
USER_SEGMENTS
|
|
|
|