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_DMT_USED_EXTENTS

Object Details

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

All extents in the dictionary managed tablespaces

[View Source]

Columns

Name	Datatype	Mandatory	Comments
SEGMENT_FILEID	NUMBER	Yes	File number of segment header of the extent
SEGMENT_BLOCK	NUMBER	Yes	Block number of segment header of the extent
TABLESPACE_ID	NUMBER	Yes	ID of the tablespace containing the extent
EXTENT_ID	NUMBER	Yes	Extent number in the segment
FILEID	NUMBER	Yes	File Number of the extent
BLOCK	NUMBER	Yes	Starting block number of the extent
LENGTH	NUMBER	Yes	Number of blocks in the extent

Query Text

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


SELECT SEGMENT_FILEID
,      SEGMENT_BLOCK
,      TABLESPACE_ID
,      EXTENT_ID
,      FILEID
,      BLOCK
,      LENGTH
FROM SYS.DBA_DMT_USED_EXTENTS;

Dependencies

[top of page]

SYS.DBA_DMT_USED_EXTENTS references the following:

SYS: RECYCLEBIN$; UET$

SYS.DBA_DMT_USED_EXTENTS is referenced by following:

PUBLIC: DBA_DMT_USED_EXTENTS