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_OLD

Object Details

Object Name:	DBA_SEGMENTS_OLD
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"
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
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

Query Text

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


SELECT OWNER
,      SEGMENT_NAME
,      PARTITION_NAME
,      SEGMENT_TYPE
,      TABLESPACE_NAME
,      HEADER_FILE
,      HEADER_BLOCK
,      BYTES
,      BLOCKS
,      EXTENTS
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENTS
,      MAX_EXTENTS
,      PCT_INCREASE
,      FREELISTS
,      FREELIST_GROUPS
,      RELATIVE_FNO
,      BUFFER_POOL
FROM SYS.DBA_SEGMENTS_OLD;

Dependencies

[top of page]

SYS.DBA_SEGMENTS_OLD references the following:

SYS: DBMS_SPACE_ADMIN - show dependent code; SYS_DBA_SEGS

SYS.DBA_SEGMENTS_OLD is referenced by following:

PUBLIC: DBA_SEGMENTS_OLD