Asset Reporting - Data Files

 

Use this report to view information about the data files within your environment. Some of the following fields are not available for all RDBMSs:

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

fully-qualified path name to a physical data file

Used Space

amount of space used by a data file

Percent Used

percentage of allocated space that a data file is consuming

Free Space

amount of free space in a data file

Percent Free

percentage of free space available in a data file

Total Size

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 whether the RDBMS should automatically increase the size of data files when they fill up with data

Growth

percentage that a data file will grow if it becomes full

Maximum Size

maximum size to which the RDBMS will auto extend a data file

Create Time

date/time when a data file was created

Discovered Time

date/time when a data file was discovered