Show datafiles and their size


SELECT tablespace_name, file_name, bytes, round(bytes/1024/1024,2) as megabytes,
f.autoextensible
FROM DBA_DATA_FILES f
order by tablespace_name, file_name

 

Leave a Reply

Your email address will not be published. Required fields are marked *