DB Wiki

User Tools

Site Tools

Trace:
usefulscripts

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
usefulscripts [2025/03/08 22:24] – external edit 127.0.0.1usefulscripts [2025/08/07 09:11] (current) – z0hpvk
Line 62: Line 62:
          df.file_name;          df.file_name;
 </code> </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> <code SQL>
 SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE FROM DBA_EXTENTS SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE FROM DBA_EXTENTS
usefulscripts.txt · Last modified: 2025/08/07 09:11 by z0hpvk