Data File Free Space (Oracle) - By Data File

 

Use this report to view capacity and free space information for the Oracle data files within your environment.

Field Name

Description

Computer

name of the computer on which a data file resides

RDBMS Instance

Instance on which a data file resides

Database

database on which a data file resides

Tablespace

tablespace with which a data file is associated

Data File Path

full path name to a data file

Free Space

amount of free space available in a data file

Percent Free

percentage of allocated space that is unused

Used Space

amount of space allocated to a data file

Total Size

total amount of space allocated to a data file

Free Extents

number of free extents for a data file

Coalesced Extents

number of coalesced extents associated with a data file

Minimum Free Extent Size

size of the smallest chunk of free space associated with a data file

Maximum Free Extent Size

size of the largest chunk of free space associated with a data file

Status

indicates the status of a data file (e.g., offline, online, etc.)

Auto Extend

indicates if a data file will auto extend

Maximum Size

 

Create Time

date/time when a data file was created

Discovered Time

date/time when a data file was discovered