Differences

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

--- usefulscripts [2019/07/23 14:01] – [Sessions] 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 152: / Line 166: @@
 ORDER BY owner, job_name;
 </code>
+<code>
+exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'TRUE');
+exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'FALSE');
+select * from DBA_SCHEDULER_GLOBAL_ATTRIBUTE;
+</code>
 ====Optimiser Statistics====
 <code SQL>
@@ Line 324: / Line 344: @@
 </code>
-====Patching====
+====Patching and Registry====
 <code SQL>
 SET LINESIZE 120
@@ Line 331: / 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>