Differences

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

--- usefulscripts [2019/07/12 15:16] – z0hpvk
+++ usefulscripts [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 101: / Line 101: @@
   from V$RESOURCE_LIMIT
  where RESOURCE_NAME in ('processes','sessions');
+</code>
+<code SQL>
+set lines 180
+col opname format a30
+col target format a40
+col start_time format a20
+col last_update_time format a20
+alter session set nls_date_format = 'DD-MON-YYYY HH24:MI';
+select inst_id, sid, serial#, opname, target, start_time, last_update_time, time_remaining, elapsed_seconds
+from gv$session_longops
+where to_char(start_time, 'DD-MON-YYYY') = to_char(sysdate, 'DD-MON-YYYY')
+and target is not null
+and time_remaining > 0
+order by elapsed_seconds DESC, start_time;
 </code>
@@ Line 135: / Line 152: @@
 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 307: / Line 330: @@
 </code>
-====Patching====
+====Patching and Registry====
 <code SQL>
 SET LINESIZE 120
@@ Line 314: / Line 337: @@
 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>