VIEW: SYS.DBA_AUTOTASK_OPERATION

Source

View Text - Preformatted

SELECT C.CNAME_KETCL,
      O.OPNAME_KETOP,
      O.OTAG_KETOP,
      NVL(DECODE(COALESCE(RC.PRIORITY_OVERRIDE, RO.PRIORITY_OVERRIDE),
                  NULL, NULL,
                     0, NULL,
                     1, 'MEDIUM',
                     2, 'HIGH',
                     3, 'URGENT','INVALID'), '  ')
          AS PRIORITY_OVERRIDE,
      dbms_auto_task.decode_attributes(
         dbms_auto_task.reconcile_attributes(C.ATTR_KETCL,
                                             RC.ATTRIBUTES,
                                              O.ATTR_KETOP,
                                              NVL(RO.ATTRIBUTES, 0),
                                              0,0)
       ) AS ATTRIBUTES,
       CASE BITAND(21,
                   dbms_auto_task.reconcile_attributes(C.ATTR_KETCL,
                   RC.ATTRIBUTES, O.ATTR_KETOP, NVL(RO.ATTRIBUTES, 0), 0,0))
       WHEN 0 THEN 'TRUE'
       ELSE 'FALSE'
       END AS USE_RESOURCE_ESTIMATES,
       CASE RC.STATUS
       WHEN 2 THEN DECODE(RO.STATUS, NULL, 'ENABLED',
                          2, 'ENABLED', 1, 'DISABLED', 'INVALID')
       WHEN 1 THEN 'DISABLED'
       ELSE 'INVALID'
       END  AS STATUS,
       RC.LAST_CHANGE
 FROM X$KETCL C, X$KETOP O, KET$_CLIENT_CONFIG RC, KET$_CLIENT_CONFIG RO
WHERE C.CID_KETCL = O.CID_KETOP
  AND C.CID_KETCL > 0
  AND C.CID_KETCL = RC.CLIENT_ID
  AND (BITAND(C.ATTR_KETCL,2048) = 0
          OR 999999 < (SELECT TO_NUMBER(VALUE)
                         FROM V$SYSTEM_PARAMETER
                        WHERE NAME = '_automatic_maintenance_test'))
  AND RC.OPERATION_ID = 0
  AND O.CID_KETOP = RO.CLIENT_ID(+)
  AND O.OPID_KETOP = RO.OPERATION_ID(+)

View Text - HTML Formatted

SELECT C.CNAME_KETCL
, O.OPNAME_KETOP
, O.OTAG_KETOP
, NVL(DECODE(COALESCE(RC.PRIORITY_OVERRIDE
, RO.PRIORITY_OVERRIDE)
, NULL
, NULL
, 0
, NULL
, 1
, 'MEDIUM'
, 2
, 'HIGH'
, 3
, 'URGENT'
, 'INVALID')
, ' ') AS PRIORITY_OVERRIDE
, DBMS_AUTO_TASK.DECODE_ATTRIBUTES( DBMS_AUTO_TASK.RECONCILE_ATTRIBUTES(C.ATTR_KETCL
, RC.ATTRIBUTES
, O.ATTR_KETOP
, NVL(RO.ATTRIBUTES
, 0)
, 0
, 0) ) AS ATTRIBUTES
, CASE BITAND(21
, DBMS_AUTO_TASK.RECONCILE_ATTRIBUTES(C.ATTR_KETCL
, RC.ATTRIBUTES
, O.ATTR_KETOP
, NVL(RO.ATTRIBUTES
, 0)
, 0
, 0)) WHEN 0 THEN 'TRUE' ELSE 'FALSE' END AS USE_RESOURCE_ESTIMATES
, CASE RC.STATUS WHEN 2 THEN DECODE(RO.STATUS
, NULL
, 'ENABLED'
, 2
, 'ENABLED'
, 1
, 'DISABLED'
, 'INVALID') WHEN 1 THEN 'DISABLED' ELSE 'INVALID' END AS STATUS
, RC.LAST_CHANGE
FROM X$KETCL C
, X$KETOP O
, KET$_CLIENT_CONFIG RC
, KET$_CLIENT_CONFIG RO WHERE C.CID_KETCL = O.CID_KETOP
AND C.CID_KETCL > 0
AND C.CID_KETCL = RC.CLIENT_ID
AND (BITAND(C.ATTR_KETCL
, 2048) = 0 OR 999999 < (SELECT TO_NUMBER(VALUE)
FROM V$SYSTEM_PARAMETER
WHERE NAME = '_AUTOMATIC_MAINTENANCE_TEST'))
AND RC.OPERATION_ID = 0
AND O.CID_KETOP = RO.CLIENT_ID(+)
AND O.OPID_KETOP = RO.OPERATION_ID(+)