Size of a Oracle datafile (and temp datafile)
SELECT file_name, autoextensible, round(bytes/1024/1024,2) as bytes_in_mb, round(maxbytes/1024/1024,2) as maxbytes_in_mb FROM dba_data_files WHERE file_name like '%datafile%';
SELECT file_name, autoextensible, round(bytes/1024/1024,2) as bytes_in_mb, round(maxbytes/1024/1024,2) as maxbytes_in_mb FROM dba_temp_files WHERE file_name like '%tempdatafile%';
sdmrnv, 2019-07-09 [0.596ms, r]