・データファイル、サイズの簡易確認用SQL
いつも探すのでメモ
set linesize 250 set pagesize 1000 col TABLESPACE_NAME format a30 heading TS_NAME col FILE_NAME format a50 col "SIZE(MB)" format 999,999,990 col "USED(MB)" format 999,999,990 col "FREE(MB)" format 999,999,990 select d.FILE_ID, d.tablespace_name, d.FILE_NAME, d.STATUS, d.BYTES / 1024 /1024 "SIZE(MB)", (d.BYTES - f.BYTES) / 1024 /1024 "USED(MB)", f.BYTES / 1024 /1024 "FREE(MB)" from dba_data_files d, v$filestat s, (select file_id, sum(bytes) bytes, sum(blocks) blocks from dba_free_space group by file_id ) f where d.FILE_ID=f.FILE_ID and d.FILE_ID=s.FILE# order by d.FILE_NAME ;