eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_SEGMENTS

Object Details

Object Name:	DBA_SEGMENTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Storage allocated for all database segments

[View Source]

Columns

Name	Datatype	Length	Comments
OWNER	VARCHAR2	(128)	Username of the segment owner
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
HEADER_FILE	NUMBER		ID of the file containing the segment header
HEADER_BLOCK	NUMBER		ID of the block containing the segment header
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 in this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
RELATIVE_FNO	NUMBER		Relative number of the file containing the segment header
BUFFER_POOL	VARCHAR2	(7)	The default buffer pool to be used for segments blocks
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      SEGMENT_NAME
,      PARTITION_NAME
,      SEGMENT_TYPE
,      SEGMENT_SUBTYPE
,      TABLESPACE_NAME
,      HEADER_FILE
,      HEADER_BLOCK
,      BYTES
,      BLOCKS
,      EXTENTS
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENTS
,      MAX_EXTENTS
,      MAX_SIZE
,      RETENTION
,      MINRETENTION
,      PCT_INCREASE
,      FREELISTS
,      FREELIST_GROUPS
,      RELATIVE_FNO
,      BUFFER_POOL
,      FLASH_CACHE
,      CELL_FLASH_CACHE
,      INMEMORY
,      INMEMORY_PRIORITY
,      INMEMORY_DISTRIBUTE
,      INMEMORY_DUPLICATE
,      INMEMORY_COMPRESSION
FROM SYS.DBA_SEGMENTS;

Dependencies

[top of page]

SYS.DBA_SEGMENTS references the following:

SYS: DBMS_SPACE_ADMIN - show dependent code; SYS_DBA_SEGS

SYS.DBA_SEGMENTS is referenced by following:

DBSNMP: DBA_SEGMENTS
PUBLIC: DBA_SEGMENTS
SYS: DBMS_DBFS_SFS_ADMIN - show dependent code; DBMS_HEAT_MAP - show dependent code; DBMS_REGISTRY_SYS - show dependent code; DBMS_SQLTCB_INTERNAL - show dependent code; DBMS_STATS_INTERNAL - show dependent code; SM$TS_USED; TS_PITR_OBJECTS_TO_BE_DROPPED; WRI$_ADV_OBJSPACE_TREND_T