Skip to content

Instantly share code, notes, and snippets.

@dotmaik1

dotmaik1/datafiles: datafiles information.sql

Created October 6, 2016 17:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dotmaik1/a2af965e60a3ea159f6f8682212fd804 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dotmaik1/a2af965e60a3ea159f6f8682212fd804 to your computer and use it in GitHub Desktop.
Download ZIP
datafiles information
Raw
datafiles: datafiles information.sql
SET LINESIZE 200
SET PAGES 500
COLUMN file_name FORMAT A70
SELECT file_id,
file_name,
ROUND(bytes/1024/1024) AS size_mb,
ROUND(maxbytes/1024/1024) AS max_size_mb,
autoextensible,
increment_by,
status
FROM dba_data_files
ORDER BY file_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment