Oracle常用脚本-每个表使用了多少空间

CREATE OR REPLACE VIEW db_table_used (
   segment_name,
   used_mb )
AS
SELECT   segment_name, SUM (BYTES) / 1024 / 1024 as Used_MB
    FROM user_extents
GROUP BY segment_name
order by Used_MB desc
/