Differences

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

--- usefulscripts [2020/02/06 13:41] – z0hpvk
+++ 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
@@ Line 330: / Line 344: @@
 </code>
-====Patching====
+====Patching and Registry====
 <code SQL>
 SET LINESIZE 120
@@ Line 337: / Line 351: @@
 select PATCH_ID, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH;
+</code>
+<code SQL>
+SET LINESIZE 120
+COL COMP_NAME FORMAT A40
+COL VERSION FORMAT A20
+select COMP_NAME, VERSION, STATUS from DBA_REGISTRY;
 </code>