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.SYS_DBA_SEGS

Object Details

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

[View Source]

Columns

Name	Datatype	Length
OWNER	VARCHAR2	(128)
SEGMENT_NAME	VARCHAR2	(128)
PARTITION_NAME	VARCHAR2	(128)
SEGMENT_TYPE	VARCHAR2	(18)
SEGMENT_TYPE_ID	NUMBER
SEGMENT_SUBTYPE	VARCHAR2	(10)
TABLESPACE_ID	NUMBER
TABLESPACE_NAME	VARCHAR2	(30)
BLOCKSIZE	NUMBER
HEADER_FILE	NUMBER
HEADER_BLOCK	NUMBER
BYTES	NUMBER
BLOCKS	NUMBER
EXTENTS	NUMBER
INITIAL_EXTENT	NUMBER
NEXT_EXTENT	NUMBER
MIN_EXTENTS	NUMBER
MAX_EXTENTS	NUMBER
MAX_SIZE	NUMBER
RETENTION	VARCHAR2	(7)
MINRETENTION	NUMBER
PCT_INCREASE	NUMBER
FREELISTS	NUMBER
FREELIST_GROUPS	NUMBER
RELATIVE_FNO	NUMBER
BUFFER_POOL_ID	NUMBER
FLASH_CACHE	NUMBER
CELL_FLASH_CACHE	NUMBER
SEGMENT_FLAGS	NUMBER
SEGMENT_OBJD	NUMBER

Query Text

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


SELECT OWNER
,      SEGMENT_NAME
,      PARTITION_NAME
,      SEGMENT_TYPE
,      SEGMENT_TYPE_ID
,      SEGMENT_SUBTYPE
,      TABLESPACE_ID
,      TABLESPACE_NAME
,      BLOCKSIZE
,      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_ID
,      FLASH_CACHE
,      CELL_FLASH_CACHE
,      SEGMENT_FLAGS
,      SEGMENT_OBJD
FROM SYS.SYS_DBA_SEGS;

Dependencies

[top of page]

SYS.SYS_DBA_SEGS references the following:

SYS: FILE$; OBJ$; SEG$; SYS_OBJECTS; TS$; UNDO$; USER$

SYS.SYS_DBA_SEGS is referenced by following:

SYS: DBA_EXTENTS; DBA_SEGMENTS; DBA_SEGMENTS_OLD; DBMS_CACHEUTIL - show dependent code; DBMS_HEAT_MAP - show dependent code; DBMS_SPACE - show dependent code