03 Datafiles Autoextend Capacity

oracle_dba_perf_toolkit/daily_dba/03_datafiles_autoextend_capacity.sql

Disclaimer: This script is provided for educational and learning purposes. Review it carefully, test in a non-production environment, confirm privileges, and validate impact before using it in production.

SET PAGESIZE 200
SET LINESIZE 240
SET TRIMSPOOL ON
SET VERIFY OFF
SET FEEDBACK ON
SET TAB OFF

COLUMN tablespace_name FORMAT A25
COLUMN file_name FORMAT A80
COLUMN autoextensible FORMAT A5
COLUMN current_mb FORMAT 999,999,999.99
COLUMN max_mb FORMAT 999,999,999.99

SELECT
    tablespace_name,
    file_name,
    autoextensible,
    ROUND(bytes / 1024 / 1024, 2) current_mb,
    ROUND(maxbytes / 1024 / 1024, 2) max_mb
FROM
    dba_data_files
ORDER BY
    tablespace_name,
    file_name;