DBA Data Files – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Database Administration · all Database Administration reports

Overview

Data and temp files per tablespace with their size, free space, autoextend settings and the space still available up to the maximum size.

All sizes are shown in MB.

Available Size and Max Used Percent take autoextend into account, so they show how close a file is to its real limit. Used and free space of temp files are shown by DBA Tablespace Usage.

In Backup Mode flags data files left in hot backup mode (alter tablespace … begin backup).

Schedule the report with Max Used Percent From, for example 90, to get an email only when a data file is close to full.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Tablespace, Max Used Percent From

Oracle EBS Tables Used

dba_data_files, dba_tablespaces, v$backup, dba_free_space, dba_temp_files

Report Categories

Enginatics

DBA Tablespace Usage, DBA Blocking Sessions, DBA SGA Active Session History, DBA AWR Active Session History, DBA SGA Buffer Cache Object Usage, DBA SGA+PGA Memory Configuration, DBA Sessions, Blitz Report Web Service Sessions, DBA Undo Statistics

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output DBA Data Files 12-Oct-2026 061632.xlsx
Blitz Report™ XML Import DBA_Data_Files.xml
SQL Source DBA Data Files.sql
Full Report on Enginatics www.enginatics.com/reports/dba-data-files/

Case Study & Technical Analysis: DBA Data Files

Executive Summary

The DBA Data Files report lists every data file and temp file in the database, grouped by tablespace, with its size, free space, autoextend settings and the space still available up to its maximum size. All sizes are shown in MB. Database administrators use it to see how close each file is to its real limit, which is the figure that matters for autoextend files, and to find files left in backup mode. It can also be scheduled with a Max Used Percent threshold so that an email is sent only when a data file is close to full.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. DBA_DATA_FILES is joined to DBA_TABLESPACES on tablespace name, and to V$BACKUP on file number, which is an outer join so files not in backup still appear.
  2. An inline view sums DBA_FREE_SPACE by file ID, and this result is outer joined to the data files, so a file with no free space still returns its full size as used.
  3. A second query branch reads DBA_TEMP_FILES joined to DBA_TABLESPACES, and returns the temp file size and available size, with the usage columns set to null.
  4. The two branches are combined with UNION ALL and ordered by tablespace name and file name.

Parameters & Filtering

Performance & Optimization

FAQ

Q: Why is Available Size different from Free Size? A: Available Size adds the space still available through autoextend up to the maximum size, while Free Size only counts free space inside the current file size. Q: How do I get an alert only for files that are nearly full? A: Set Max Used Percent From to a threshold such as 90 and schedule the report, so only files at or above that level are returned. Q: Why are the usage columns blank for temp files? A: Temp file usage is reported by DBA Tablespace Usage, so this report shows only the size and available space for temp files.

© Enginatics GmbH