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
Next revision		Previous revision
usefulscripts [2019/07/23 14:01] – [Sessions] z0hpvkusefulscripts [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 152: Line 152:
 ORDER BY owner, job_name; ORDER BY owner, job_name;
 </code> </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==== ====Optimiser Statistics====
 <code SQL> <code SQL>
Line 324: Line 330:
 </code> </code>
  
-====Patching====+====Patching and Registry====
 <code SQL> <code SQL>
 SET LINESIZE 120 SET LINESIZE 120
Line 331: Line 337:
  
 select PATCH_ID, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH; 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> </code>
  
usefulscripts.1563890516.txt.gz · Last modified: 2025/03/08 22:23 (external edit)