实际是页的数量,不是MB单位
983040*32K/1024/1024=30G
这才是常见的文件大小
查看文件使用率
-
SELECT t.NAME,GROUP_ID,D.PATH,
-
d.TOTAL_SIZE*page()/1024/1024 AS TOTAL_SIZE_MB,
-
d.FREE_SIZE*page()/1024/1024 AS FREE_SIZE_MB,
-
ROUND((d.TOTAL_SIZE-FREE_SIZE+0.1-0.1)/d.TOTAL_SIZE*100,2) AS used_per
- FROM V$DATAFILE d,V$TABLESPACE t where d.group_id=t.id;
-