查看oracle数据库datafile的路径和大小

spool /home/oracle/datafile2021.txt
 

    select a.file  as "数据文件id",
          a.name as "数据文件路径",
          a.bytes / 1024 / 1024 as "当前数据文件大小(MB)"
    from v$datafile a

spool off