Differences

This shows you the differences between two versions of the page.

--- usefulscripts [2025/03/08 22:24] – external edit 127.0.0.1
+++ usefulscripts [2025/08/07 09:11] (current) – z0hpvk
@@ Line 62: / Line 62: @@
          df.file_name;
 </code>
+<code SQL>
+SET linesize 140
+COL owner FORMAT a15
+COL segment_name FORMAT a35
+SELECT owner, segment_name, round(sum(bytes)/1024/1024,2) "SIZE MB",
+round(sum(bytes)/1024/1024/1024,2) "SIZE GB"
+FROM dba_segments
+GROUP BY owner, segment_name
+HAVING sum(bytes) > 102400000
+ORDER BY bytes DESC;
+</code>
 <code SQL>
 SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE FROM DBA_EXTENTS