SQL> select file_size*8/1024/1024,file_maxsize*8/1024/1024 from v$filespace_usage where tablespace_id=6;
FILE_SIZE*8/1024/1024 FILE_MAXSIZE*8/1024/1024
--------------------- ------------------------
               288,75         32767,9999771118

SQL>  

SQL> select bytes/1024/1024,maxbytes/1024/1024 from dba_data_files where file_id=5;
BYTES/1024/1024 MAXBYTES/1024/1024
--------------- ------------------
         295680   33554431,9765625
 

SQL> select used_space*8/1024/1024,tablespace_size*8/1024/1024,used_percent from dba_tablespace_usage_metrics where tablespace_name='R1AFR';
USED_SPACE*8/1024/1024 TABLESPACE_SIZE*8/1024/1024 USED_PERCENT
---------------------- --------------------------- ------------
          279,17578125            323,519500732422 86,293339541

SQL>