-
SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 "Size_MB", MAXBYTES/1024/1024 "MaxSize_MB", AUTOEXTENSIBLE FROM DBA_DATA_FILES ORDER BY BYTES/1024/1024 DESC ;