SELECT owner,
segment_name,
SUM(bytes /1024/1024 /1024) sum
FROM dba_segments
GROUP BY owner,segment_name
having SUM(bytes /1024/1024 /1024) >2
ORDER BY 3 DESC
segment_name,
SUM(bytes /1024/1024 /1024) sum
FROM dba_segments
GROUP BY owner,segment_name
having SUM(bytes /1024/1024 /1024) >2
ORDER BY 3 DESC