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
/
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
/