| SQL Id | SQL Text |
|---|
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0njp59jttu2z9 | DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1 |
| 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
| 0y166n0ukd63a | SELECT M.METRIC_GUID, M.METRIC_TYPE, M.METRIC_NAME, M.NUM_KEYS, M.IS_REPOSITORY, M.IS_TRANSPOSED, M.SOURCE_TYPE, M.KEY_ORDER, M.METRIC_COLUMN, M.KEYS_FROM_MULT_COLLS FROM MGMT_METRICS M, MGMT_TARGETS T WHERE M.METRIC_NAME = (SELECT DISTINCT(METRIC_NAME) FROM MGMT_METRICS WHERE METRIC_GUID = :B2 ) AND T.TARGET_GUID = :B1 AND M.TARGET_TYPE = T.TARGET_TYPE AND M.TYPE_META_VER = T.TYPE_META_VER AND (M.CATEGORY_PROP_1 = T.CATEGORY_PROP_1 OR M.CATEGORY_PROP_1 = ' ') AND (M.CATEGORY_PROP_2 = T.CATEGORY_PROP_2 OR M.CATEGORY_PROP_2 = ' ') AND (M.CATEGORY_PROP_3 = T.CATEGORY_PROP_3 OR M.CATEGORY_PROP_3 = ' ') AND (M.CATEGORY_PROP_4 = T.CATEGORY_PROP_4 OR M.CATEGORY_PROP_4 = ' ') AND (M.CATEGORY_PROP_5 = T.CATEGORY_PROP_5 OR M.CATEGORY_PROP_5 = ' ') ORDER BY DECODE(METRIC_COLUMN, ' ', 1, 2), DECODE(KEY_ORDER, 0, 1, 0) , KEY_ORDER, METRIC_COLUMN |
| 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256)) |
| 19x1189chq3xd | SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE |
| 1cq3qr774cu45 | insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id) |
| 1nx1518vff191 | UPDATE MGMT_COLLECTION_TASKS SET TASK_TYPE=NVL(:B14 , TASK_TYPE), PRIORITY=NVL(:B13 , PRIORITY), NEXT_COLLECTION_TIMESTAMP=NVL(:B12 , NEXT_COLLECTION_TIMESTAMP), LAST_COLLECTION_TIMESTAMP=NVL(:B11 , LAST_COLLECTION_TIMESTAMP), ERROR_MESSAGE=:B10 , FAILURES=NVL(:B9 , FAILURES), TOTAL_RUNS=NVL(:B8 , TOTAL_RUNS), MIN_WAIT_TIME=NVL(:B7 , MIN_WAIT_TIME), MAX_WAIT_TIME=NVL(:B6 , MAX_WAIT_TIME), AVG_WAIT_TIME=NVL(:B5 , AVG_WAIT_TIME), MIN_RUN_TIME=NVL(:B4 , MIN_RUN_TIME), MAX_RUN_TIME=NVL(:B3 , MAX_RUN_TIME), AVG_RUN_TIME=NVL(:B2 , AVG_RUN_TIME) WHERE TASK_ID = :B1 RETURNING FREQUENCY_CODE, PRIORITY, TASK_TYPE, NEXT_COLLECTION_TIMESTAMP, TASK_CLASS INTO :O0 , :O1 , :O2 , :O3 , :O4 |
| 1pxym63gwyq39 | UPDATE AconProcsB SET TASKTYPE = :1 , TASKDESC = :2 , STATUSTIMESTAMP = :3 , AGENTTIMESTAMP = :4 , LASTRECORDTIME = :5 , DATASOURCE = :6 , DATASOURCETYPE = :7 , TANDEMPROCESS = :8 WHERE URISTRING = :9 |
| 1t0vfvhmyjq5c | SELECT NVL(AVG(VALUE) , 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME='Notification Delivery' AND NAME='Delivery Time' AND TIME>(SYSDATE-(1/24)) |
| 1tgukkrqj3zhw | SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND ((CLSOID IS NOT NULL AND INST_ID IS NULL AND CLSOID IN (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :8) <> 0 and lower(e.affinity) = lower(:9))) OR (INST_ID IS NOT NULL AND INST_ID = :10)) ORDER BY 2, 3, 4 DESC |
| 1zcyc7wgvf8yt | SELECT MAX(SEQUENCENUM) FROM LogEntryB WHERE (URISTRING LIKE '%10.90.130.99:7839%' OR URISTRING LIKE '%10.212.9.158:7839%' OR URISTRING LIKE '%10.90.18.115:7839%' OR URISTRING LIKE '%10.90.130.12:7939%' OR URISTRING LIKE '%10.90.130.34:7939%' OR URISTRING LIKE '%10.90.130.11:7839%' OR URISTRING LIKE '%10.218.15.52:7839%' OR URISTRING LIKE '%10.217.1.12:7839%' OR URISTRING LIKE '%10.90.82.103:7839%' OR URISTRING LIKE '%10.134.5.155:7839%' OR URISTRING LIKE '%10.90.130.36:7939%' OR URISTRING LIKE '%10.118.81.72:7839%' OR URISTRING LIKE '%10.90.130.33:7839%' OR URISTRING LIKE '%10.160.231.36:7839%' OR URISTRING LIKE '%10.124.96.1:7839%' OR URISTRING LIKE '%10.90.130.14:7939%' OR URISTRING LIKE '%10.172.78.42:7839%' OR URISTRING LIKE '%10.165.0.4:7839%') AND (ENTLEVEL=:1 OR ENTLEVEL=:2 OR ENTLEVEL=:3) AND ((COMMONNAME LIKE 'source_jb' AND PROCESSNAME IN('EXT_KA'))) |
| 2401ghqf3d8a4 | SELECT WL0.FQDN, WL0.PORT, WL0.COMMONNAME, WL0.DBCODE, WL0.DEFAULTDSN, WL0.DEFAULTPASSWORD, WL0.DEFAULTUSERID, WL0.GGSVERSION, WL0.PLATFORMCODE FROM HostInfoB WL0 WHERE ( WL0.COMMONNAME = :1 ) |
| 25gyh8av7kjzc | SELECT MAX(TIMEVALUE) FROM StatsEntryB WHERE MEASUREMENT = :1 AND URISTRING = :2 |
| 26djmqa9kmk6z | SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number |
| 2a99kfa1dykuy | update wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (select decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (ts#, obj#, dataobj#) in (select tsn_kewrseg, objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = 'INDEX' |
| 2b064ybzkwf1y | BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; |
| 2d93bytu1xg1d | INSERT INTO MGMT_JOB_HISTORY(JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, STEP_STATUS_CODE, NUM_CHILDREN, NUM_CHILDREN_COMPLETED, OUTPUT_ID, ERROR_ID, START_TIME, END_TIME, TIMEZONE_REGION, SEQUENCE_NUMBER, DISPATCHER_ID) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 ) |
| 2wg1t7w3r23sw | SELECT URISTRING, COMMONNAME, PROCESSNAME, PROCESSTYPE, INSERTTIMESTAMP, SOURCETIMESTAMP, TZOFFSET, ENTLEVEL, SOURCE, ENTNUMBER, ENTTEXT, ACKNOWLEDGEDBY, ACKNOWLEDGEDTIMESTAMP, SEQUENCENUM FROM LogEntryB WHERE (URISTRING LIKE '%10.90.130.99:7839%' OR URISTRING LIKE '%10.212.9.158:7839%' OR URISTRING LIKE '%10.90.18.115:7839%' OR URISTRING LIKE '%10.90.130.12:7939%' OR URISTRING LIKE '%10.90.130.34:7939%' OR URISTRING LIKE '%10.90.130.11:7839%' OR URISTRING LIKE '%10.218.15.52:7839%' OR URISTRING LIKE '%10.217.1.12:7839%' OR URISTRING LIKE '%10.90.82.103:7839%' OR URISTRING LIKE '%10.134.5.155:7839%' OR URISTRING LIKE '%10.90.130.36:7939%' OR URISTRING LIKE '%10.118.81.72:7839%' OR URISTRING LIKE '%10.90.130.33:7839%' OR URISTRING LIKE '%10.160.231.36:7839%' OR URISTRING LIKE '%10.124.96.1:7839%' OR URISTRING LIKE '%10.90.130.14:7939%' OR URISTRING LIKE '%10.172.78.42:7839%' OR URISTRING LIKE '%10.165.0.4:7839%') AND (ENTLEVEL=:1 OR ENTLEVEL=:2 OR ENTLEVEL=:3) AND ((COMMONNAME LIKE 'source_xj' AND PROCESSNAME IN('EXT_KA'))) ORDER BY SOURCETIMESTAMP DESC |
| 2wuxsvgst612h | SELECT NVL(AVG(VALUE), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME=:B2 AND NAME=:B1 AND TIME>(SYSDATE-(1/24)) |
| 317v5hnvvd49h | UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat) |
| 35y2u24f4rxqm | insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , sys.dbms_swrf_internal.awr_decode_object_type(ss1.objtype_kewrseg) , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 5, 6, 7, 8, 9)))) and ss1.objname_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_' |
| 39c8q6w3s3r8y | UPDATE MGMT_EMD_PING_CHECK SET LAST_CHECKED_UTC = :B1 WHERE TARGET_GUID IN (SELECT PING.TARGET_GUID FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC WHERE PING.TARGET_GUID = PINGC.TARGET_GUID AND PING.MAX_INACTIVE_TIME > 0 AND ( (PING.STATUS = :B3 ) OR (PING.STATUS = :B2 ) ) AND (:B1 - PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) |
| 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values) |
| 3d0537zmn35rz | insert into wrh$_sess_time_stats (snap_id, dbid, instance_number, session_type, min_logon_time, sum_cpu_time, sum_sys_io_wait, sum_user_io_wait) select :snap_id, :dbid, :instance_number, type, min(logon_time) min_logon_time, sum(cpu_time) cpu_time, sum(sys_io_wait) sys_io_wait, sum(user_io_wait) user_io_wait from (select sid, serial#, max(type) type, max(logon_time) logon_time, max(cpu_time) cpu_time, sum(case when kslcsclsname = 'System I/O' then kslcstim else 0 end) as sys_io_wait, sum(case when kslcsclsname ='User I/O' then kslcstim else 0 end) as user_io_wait from (select /*+ ordered */ allsids.sid sid, allsids.serial# serial#, max(type) type, max(logon_time) logon_time, sum(kewsval) cpu_time from (select type, allsids.sid, sess.ksuseser as serial#, sess.ksuseltm as logon_time from (select /*+ ordered index(p) */ s.indx as sid, decode(l.role, 'reader', 'Logminer Reader', 'preparer', 'Logminer Preparer', 'builder', 'Logminer Builder') as type from x$logmnr_process l, x$ksupr p, x$ksuse s where l.role in ('reader', 'preparer', 'builder') and l.pid = p.indx and bitand(p.ksspaflg, 1)!=0 and p.ksuprpid = s.ksusepid union all select sid_knst as sid, decode(type_knst, 8, 'STREAMS Capture', 7, 'STREAMS Apply Reader', 2, 'STREAMS Apply Server', 1, 'STREAMS Apply Coordinator') as type from x$knstcap where type_knst in (8, 7, 2, 1) union all select indx as sid, (case when ksusepnm like '%(Q00%)' then 'QMON Slaves' else 'QMON Coordinator' end) as type from x$ksuse where ksusepnm like '%(Q00%)' or ksusepnm like '%(QMNC)' union all select kwqpssid as sid, 'Propagation Sender' as type from x$kwqps union all select kwqpdsid as sid, 'Propagation Receiver' as type from x$kwqpd union all select proxy_sid_knstasl as sid, 'Apply Network Receiver' as type from x$knstasl a where type_knst = 7 and proxy_sid_knstasl is not null and not exists (select 1 from x$knstcap x where type_knst = 8 and x.sid_knst = a.proxy_sid_knstasl) ) allsids, x$ksuse sess where bitand(sess.ksspaflg, 1) != 0 and bitand(sess.ksuseflg, 1) != 0 and allsids.sid = sess.indx) allsids, x$kewssesv sesv, x$kewssmap map where allsids.sid = sesv.ksusenum and sesv.kewsnum = map.soffst and map.aggid = 1 and (map.stype = 2 or map.stype = 3) and map.sname in ('DB CPU', 'background cpu time') group by sid, serial#) allaggr, x$kslcs allio where allaggr.sid = allio.kslcssid(+) and allio.kslcsclsname in ('System I/O', 'User I/O') group by allaggr.sid, allaggr.serial#) group by type |
| 3x0kdm7z3yasw | SELECT TARGET_TYPE, TYPE_META_VER, NVL(CATEGORY_PROP_1, ' '), NVL(CATEGORY_PROP_2, ' '), NVL(CATEGORY_PROP_3, ' '), NVL(CATEGORY_PROP_4, ' '), NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 |
| 411xbxg1s65d0 | UPDATE AconProcsB SET TASKTYPE = :1 , TASKDESC = :2 , STATUSTIMESTAMP = :3 , AGENTTIMESTAMP = :4 , LASTRECORDTIME = :5 , DATASOURCE = :6 , TANDEMPROCESS = :7 WHERE URISTRING = :8 |
| 458b4zurdv3hv | UPDATE AutoIncB SET LASTINTEGER = :1 WHERE NAME = :2 |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 4gjq0xf0rw497 | SELECT /*+ cardinality(d 20) */ MAX(MGMT_GLOBAL.ADJUST_TZ(MARKER_TIMESTAMP, T.TIMEZONE_REGION, :B3 )) FROM MGMT_AVAILABILITY_MARKER M, MGMT_TARGETS T, TABLE(CAST(:B1 AS MGMT_METRIC_DETAILS_ARRAY)) D WHERE T.TARGET_GUID = M.TARGET_GUID AND T.TARGET_GUID = D.TARGET_GUID AND M.MARKER_AVAIL_STATUS = :B2 |
| 4jrfrtx4u6zcx | SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC |
| 4k748dbwn9y9c | update TASK_INSTANCE set ATTR1=:1 , ATTR2=:2 , ATTR3=:3 , ATTR4=:4 , ATTR5=:5 , CIRCLE_WAY=:6 , CREATE_SERVER_IP=:7 , CREATE_SERVER_NAME=:8 , CREATE_TIME=:9 , CREATOR_ID=:10 , CREATOR_IP=:11 , CREATOR_NAME=:12 , DELAY_STRATEGY=:13 , TASK_DESCRIPTION=:14 , END_TIME=:15 , ENGINE_ID=:16 , EXCEPTION_ID=:17 , EXECUTE_END_TIME=:18 , EXECUTE_SECONDS=:19 , EXECUTE_START_TIME=:20 , EXECUTE_TIME_RULE=:21 , EXECUTE_CLASS=:22 , TASK_GROUP=:23 , LAST_MODIFY_STATUS_TIME=:24 , TASK_LAUNCHER=:25 , MSG_RECEIVER=:26 , TASK_NAME=:27 , NEXT_EXECUTE_TIME=:28 , ORG_ID=:29 , PARAMETER_ID=:30 , TASK_PRIORITY=:31 , ISRELIABLE=:32 , SEND_MSG=:33 , START_TIME=:34 , TASK_STATUS=:35 , TRIED_COUNT=:36 , TRY_INTERVAL_SECONDS=:37 , TRY_MAX_COUNT=:38 , TASK_TYPE=:39 where TASK_ID=:40 |
| 4m9bapf9sj3sf | SELECT mgmt_metric_value_obj.new(target_guid, null, null, mgmt_namevalue_array(mgmt_namevalue_obj.new('privTransferRate', privTransferRate))) from ( SELECT ta.source_target_guid target_guid, SUM(c.value) privTransferRate FROM mgmt_current_metrics c, mgmt_current_availability a, mgmt_targets t2, mgmt_target_assocs ta, mgmt_target_assoc_defs td, mgmt_ha_cls_intr_conn i, mgmt_ecm_gen_snapshot s WHERE c.metric_guid = HEXTORAW('F77CC469F1DBA385991ACF69FEB4E329') AND c.target_guid = t2.target_guid AND a.target_guid = t2.target_guid AND a.current_status > 0 AND t2.target_guid = ta.assoc_target_guid AND ta.assoc_guid = td.assoc_guid AND td.assoc_def_name = 'contains' AND td.scope_target_type = ' ' AND (i.ic_node = 'global' or i.ic_node = t2.target_name) AND i.ic_public = 'NO' AND i.ecm_snapshot_id = s.snapshot_guid AND s.snapshot_type = 'ha_cls_intrconn' AND s.is_current = 'Y' AND s.target_guid = ta.source_target_guid AND i.ic_name = c.key_value AND t2.target_type = 'host' GROUP BY ta.source_target_guid ) WHERE target_guid IN (SELECT target_guid FROM MGMT_COLLECTION_METRIC_TASKS WHERE TASK_ID = :task_id) order by target_guid |
| 4xxfmvn2m75q4 | /* OracleOEM */ select * from (select instance_name c1 from v$instance), (select value from v$parameter where name like 'db_block_size'), (select value from v$sysstat where name='gc cr blocks received'), (select value from v$sysstat where name='gc current blocks received'), (select value from v$sysstat where name='gc cr blocks served'), (select value from v$sysstat where name='gc current blocks served'), (select value from V$dlm_misc where name='messages sent directly'), (select value from V$dlm_misc where name='messages sent indirectly'), (select value from V$dlm_misc where name='messages received actual') |
| 57pfs5p8xc07w | UPDATE MGMT_TARGETS SET LAST_LOAD_TIME=:B2 WHERE TARGET_GUID = :B1 AND (LAST_LOAD_TIME < :B2 OR LAST_LOAD_TIME IS NULL) |
| 5ms6rbzdnq16t | select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job |
| 5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
| 5uy533jsc8hyh | DELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1 |
| 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; |
| 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 752xd1nphb059 | select t.target_name, t.emd_url, a.target_name, ract.racInstNum_property_value from mgmt_targets t, mgmt_target_memberships tm, (select dtp.target_guid, at.target_name from mgmt_targets at, mgmt_target_properties dtp, mgmt_target_properties atp where at.target_type = 'osm_instance' and atp.target_guid = at.target_guid and atp.property_name = 'SID' and atp.property_type = 'INSTANCE' and dtp.property_name = 'OSMInstance' and dtp.property_type = 'INSTANCE' and UPPER(dtp.property_value) = UPPER(atp.property_value)) a, (select target_guid, property_value as racInstNum_property_value from mgmt_target_properties where property_name='RACInstNum' and property_type='INSTANCE') ract where t.target_name = tm.member_target_name and t.target_type = tm.member_target_type and tm.composite_target_type = :1 and tm.composite_target_name = :2 and t.target_guid = ract.target_guid and t.target_guid = a.target_guid(+) order by t.target_name |
| 75spt1ryhh7fd | SELECT WL0.NAME, WL0.LASTINTEGER FROM AutoIncB WL0 WHERE ( WL0.NAME = :1 ) |
| 772s25v1y0x8k | select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice |
| 7vcwzqf7mgk3b | INSERT INTO MGMT_JOB_EXECUTION (JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, START_TIME, TIMEZONE_REGION) VALUES (NULL, NULL, :B5 , NULL, NULL, 0, :B4 , :B3 , :B2 , NULL, NULL, NULL, :B1 , MGMT_JOB_ENGINE.SYSDATE_UTC(), 'UTC') |
| 7yjzq240hcd2c | UPDATE /*+ INDEX(wrh$_seg_stat_obj wrh$_seg_stat_obj_index) */ wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT :lah_snap_id, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND snap_id > :lah_snap_id - 10 AND (object_name LIKE '%UNAVAIL%' OR (object_type LIKE '%UNDEF%' AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%') OR owner LIKE '%UNAVAIL%' OR tablespace_name LIKE '%UNAVAIL%') |
| 82dh89jugfs24 | SELECT MAX(SEQUENCENUM) FROM LogEntryB WHERE (URISTRING LIKE '%10.90.130.99:7839%' OR URISTRING LIKE '%10.212.9.158:7839%' OR URISTRING LIKE '%10.90.18.115:7839%' OR URISTRING LIKE '%10.90.130.12:7939%' OR URISTRING LIKE '%10.90.130.34:7939%' OR URISTRING LIKE '%10.90.130.11:7839%' OR URISTRING LIKE '%10.218.15.52:7839%' OR URISTRING LIKE '%10.217.1.12:7839%' OR URISTRING LIKE '%10.90.82.103:7839%' OR URISTRING LIKE '%10.134.5.155:7839%' OR URISTRING LIKE '%10.90.130.36:7939%' OR URISTRING LIKE '%10.118.81.72:7839%' OR URISTRING LIKE '%10.90.130.33:7839%' OR URISTRING LIKE '%10.160.231.36:7839%' OR URISTRING LIKE '%10.124.96.1:7839%' OR URISTRING LIKE '%10.90.130.14:7939%' OR URISTRING LIKE '%10.172.78.42:7839%' OR URISTRING LIKE '%10.165.0.4:7839%') AND (ENTLEVEL=:1 OR ENTLEVEL=:2 OR ENTLEVEL=:3) AND ((COMMONNAME LIKE 'source_xj' AND PROCESSNAME IN('EXT_KA'))) |
| 868nrx6fhysu8 | SELECT WL0.USERID, WL0.EMAIL, WL0.FIRSTNAME, WL0.LASTNAME, WL0.MIDDLENAME, WL0.PASSWORDHASH, WL0.PHONE FROM AccountB WL0 WHERE ( WL0.USERID = :1 ) |
| 8a5n80br7zmcy | SELECT WL0.URI, WL0.DIRTY, WL0.LASTCHECKPOINTLAG, WL0.LASTRECORDTIME, WL0.STARTTIMESTAMP, WL0.STATUS, WL0.STATUSTIMESTAMP FROM ObjectStateB WL0 WHERE ( WL0.URI = :1 ) |
| 8czn3wpfrrrnv | SELECT WL0.FQDN, WL0.PORT, WL0.COMMONNAME, WL0.DBCODE, WL0.DEFAULTDSN, WL0.DEFAULTPASSWORD, WL0.DEFAULTUSERID, WL0.GGSVERSION, WL0.PLATFORMCODE FROM HostInfoB WL0 |
| 8g4fckg01pfs4 | UPDATE AconProcsB SET TASKTYPE = :1 , TASKDESC = :2 , STATUSTIMESTAMP = :3 , AGENTTIMESTAMP = :4 , LASTRECORDTIME = :5 , LASTCHECKPOINTLAG = :6 , TANDEMPROCESS = :7 WHERE URISTRING = :8 |
| 8p9z2ztb272bm | SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number |
| 8rc705wcac4qn | SELECT TO_CHAR(COUNT(D.TARGET_NAME)) FROM MGMT_DUPLICATE_TARGETS D, MGMT_TARGETS T, MGMT_TARGETS CA WHERE D.TARGET_GUID = T.TARGET_GUID (+) AND D.DUPLICATE_EMD_URL = CA.EMD_URL AND D.RESOLVED_TIME IS NULL AND CA.TARGET_TYPE = :B1 |
| 91kjgckgn5nkw | SELECT GROUPBEAN FROM AcntGroupRel WHERE ACCOUNTBEAN = :1 |
| 96dypgvb4x88r | SELECT WL0.ALERTNAME, WL0.ACTIVE, WL0.ALERTHANDLERARGS, WL0.ALERTHANDLERCLASS, WL0.ALERTTYPE, WL0.COMMONNAME, WL0.EVENTTEXT, WL0.EVENTTYPE, WL0.LAGTHRESHOLD, WL0.PROCESSNAME, WL0.ACCOUNT FROM AlertB WL0 WHERE ( ( WL0.ALERTTYPE = :1 ) AND ( WL0.ACTIVE = :2 ) ) |
| 99tcmu5wythzf | SELECT WL0.URISTRING, WL0.AGENTTIMESTAMP, WL0.COMMONNAME, WL0.DATASOURCE, WL0.DATASOURCETYPE, WL0.LASTCHECKPOINTLAG, WL0.LASTRECORDTIME, WL0.LASTSTATUS, WL0.PARAMFILE, WL0.PROCESSNAME, WL0.PROCESSTYPE, WL0.STATUSTIMESTAMP, WL0.TANDEMCPU, WL0.TANDEMPRIORITY, WL0.TANDEMPROCESS, WL0.TASKDESC, WL0.TASKTYPE FROM AconProcsB WL0 WHERE ( ( ( WL0.COMMONNAME = :1 ) AND ( WL0.PROCESSNAME = :2 ) ) AND ( WL0.PROCESSTYPE = :3 ) ) |
| 9dhn1b8d88dpf |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name
= 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| 9f5wnd73fq9xp | DELETE FROM StatsEntryB WHERE TIMEVALUE < :1 |
| 9j65pnnvcqgda | select t.*, t2.parameter_content from task_instance t, task_instance_param t2 where t.task_status='NEW' and TASK_TYPE in (:1 ) and t.next_execute_time<=:2 and t.parameter_id = t2.parameter_id(+) order by t.task_priority desc, t.next_execute_time |
| 9p5tvdmjymwx7 | UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12 , SYSDATE), ROWS_EVALUATED = NVL(:B11 , 0), TOTAL_VIOLATIONS_LOGGED = NVL(:B10 , TOTAL_VIOLATIONS_LOGGED), NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9 , :B8 ), MAX_VIOLATION_LEVEL = NVL(:B7 , :B6 ), COMPLIANCE_SCORE = NVL(:B5 , :B4 ) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1 |
| a5mmhrrnpwjsc | SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND INST_ID IS NULL AND (CLSOID IS NULL OR (CLSOID IS NOT NULL AND (CLSOID IN (select e.obj# from sys.scheduler$_class e where e.affinity is null)))) ORDER BY 2, 3, 4 DESC |
| a8j39qb13tqkr | SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_FINDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID |
| b0320g1xasbx7 | SELECT TIMEZONE_REGION FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 |
| b2fr32n4nzub0 | UPDATE AconProcsB SET TASKTYPE = :1 , TASKDESC = :2 , STATUSTIMESTAMP = :3 , AGENTTIMESTAMP = :4 , LASTRECORDTIME = :5 , TANDEMPROCESS = :6 WHERE URISTRING = :7 |
| bbm1pcruqtx3a | SELECT PASSWORDHASH FROM AccountB WHERE USERID=:1 |
| bda5n8z5bdf34 | update TASK_ENGINE set EX_RULE1=:1 , EX_RULE2=:2 , EX_RULE3=:3 , EX_RULE4=:4 , EX_RULE5=:5 , TASK_GROUP_RULE=:6 , LAST_MODIFIED_TIME=:7 , LAST_TOUCH_TIME=:8 , ENGINE_START_ID=:9 , START_TIME=:10 , ENGINE_STATUS=:11 , TOUCH_INTERVAL=:12 , TASK_TYPE_RULE=:13 where ENGINE_IP=:14 and ENGINE_NAME=:15 |
| bn4b3vjw2mj3u | SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1 |
| bunssq950snhf | insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice |
| bunvx480ynf57 | SELECT 1 FROM DUAL |
| bzcsz9xwx1xzp | SELECT WL0.URISTRING, WL0.AGENTTIMESTAMP, WL0.COMMONNAME, WL0.DATASOURCE, WL0.DATASOURCETYPE, WL0.LASTCHECKPOINTLAG, WL0.LASTRECORDTIME, WL0.LASTSTATUS, WL0.PARAMFILE, WL0.PROCESSNAME, WL0.PROCESSTYPE, WL0.STATUSTIMESTAMP, WL0.TANDEMCPU, WL0.TANDEMPRIORITY, WL0.TANDEMPROCESS, WL0.TASKDESC, WL0.TASKTYPE FROM AconProcsB WL0 WHERE ( WL0.COMMONNAME = :1 ) |
| c1tsyvxtq28vx | SELECT WL0.PK, WL0.GOBACKHOURS, WL0.HOSTWAITSECS, WL0.IGNOREMINUTES, WL0.IGNOREOLDALERTEVENTS, WL0.LOGPURGEHOURS FROM MonAgentB WL0 WHERE ( WL0.PK = :1 ) |
| c4nhd1ntptxq7 | select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4 |
| c7rzm2g7qsy7c | SELECT NVL(SUM(VALUE), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE NAME = :B1 || 'S_QUEUED' AND TIME > (SYSDATE-(1/(24*6))) |
| cabqn4dp09qck | SELECT TASK_CLASS, ROUND(NVL(SUM(THROUGHPUT), 0), 2), NVL(SUM(TOTAL_VALUE), 0), NVL(SUM(TOTAL_DURATION), 0) FROM (SELECT CLIENT_DATA WORKER_ID, ACTION TASK_CLASS, NVL(AVG(VALUE*1000/ DECODE(DURATION, 0, 1000, DURATION)), 0) THROUGHPUT, SUM(VALUE) TOTAL_VALUE, SUM(DURATION)/1000 TOTAL_DURATION, COUNT(*) RECORDS FROM MGMT_SYSTEM_PERFORMANCE_LOG LOG WHERE LOG.JOB_NAME = :B3 AND LOG.MODULE = :B2 AND LOG.TIME > (SYSDATE-:B1 /1440) AND LOG.IS_TOTAL = 'Y' GROUP BY CLIENT_DATA, ACTION ) GROUP BY TASK_CLASS |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| ctsfqq07f876g | SELECT NVL(CRIT_COUNTER, 0), NVL(WARN_COUNTER, 0), NVL(INFO_COUNTER, 0) FROM MGMT_POLICY_ASSOC_EVAL_DETAILS WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND RESULT_KEY_VALUE = :B2 AND COLL_NAME = :B1 |
| cumjq42201t37 | select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name |
| d27r7zhtnfgp4 | SELECT LAST_DATE, THIS_DATE FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();' |
| davq1msn9b8kd | UPDATE MGMT_POLICY_ASSOC_EVAL_DETAILS SET CRIT_COUNTER = NVL(:B9 , CRIT_COUNTER), WARN_COUNTER = NVL(:B8 , WARN_COUNTER), INFO_COUNTER = NVL(:B7 , INFO_COUNTER), LAST_ERROR_MESSAGE = :B6 , LAST_EVALUATION_DATE = :B5 WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND COLL_NAME = :B2 AND RESULT_KEY_VALUE = :B1 |
| dayq182sk41ks | insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice |
| dfk7k60t4n4ka | select keyentity0_.CACHE_KEY as CACHE1_0_0_, keyentity0_.NAME as NAME0_0_, keyentity0_.STATUS as STATUS0_0_, keyentity0_.TIMESTAMP as TIMESTAMP0_0_, keyentity0_.VERSION as VERSION0_0_ from SA_CACHE_KEYSET keyentity0_ where keyentity0_.CACHE_KEY=:1 and keyentity0_.NAME=:2 |
| dfrmmfv2zbnmt | SELECT WL0.FQDN, WL0.PORT, WL0.COMMONNAME, WL0.DBCODE, WL0.DEFAULTDSN, WL0.DEFAULTPASSWORD, WL0.DEFAULTUSERID, WL0.GGSVERSION, WL0.PLATFORMCODE FROM HostInfoB WL0 WHERE ( ( WL0.FQDN = :1 ) AND ( WL0.PORT = :2 ) ) |
| dyzsh3s082wv9 | SELECT WL0.URISTRING, WL0.AGENTTIMESTAMP, WL0.COMMONNAME, WL0.DATASOURCE, WL0.DATASOURCETYPE, WL0.LASTCHECKPOINTLAG, WL0.LASTRECORDTIME, WL0.LASTSTATUS, WL0.PARAMFILE, WL0.PROCESSNAME, WL0.PROCESSTYPE, WL0.STATUSTIMESTAMP, WL0.TANDEMCPU, WL0.TANDEMPRIORITY, WL0.TANDEMPROCESS, WL0.TASKDESC, WL0.TASKTYPE FROM AconProcsB WL0 |
| f4fcb8ngpf080 | SELECT HOST_URL, MODULE, NVL(SUM(VALUE), 0) HR_THROUGHPUT, NVL(SUM(DURATION/1000.0), 0) RUNTIME, NVL((SUM(VALUE)*1000.0), 0)/ DECODE(NVL(SUM(DURATION), 0), 0, 1, SUM(DURATION)) SEC_THROUGHPUT FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME = :B3 AND MODULE LIKE :B2 ||'%' AND NAME = :B1 AND IS_TOTAL = 'Y' AND DURATION > 0 AND TIME > (SYSDATE - (1/24)) GROUP BY HOST_URL, MODULE |
| f4wg1d5m5hfkc | SELECT URISTRING, COMMONNAME, PROCESSNAME, PROCESSTYPE, INSERTTIMESTAMP, SOURCETIMESTAMP, TZOFFSET, ENTLEVEL, SOURCE, ENTNUMBER, ENTTEXT, ACKNOWLEDGEDBY, ACKNOWLEDGEDTIMESTAMP, SEQUENCENUM FROM LogEntryB WHERE (URISTRING LIKE '%10.90.130.99:7839%' OR URISTRING LIKE '%10.212.9.158:7839%' OR URISTRING LIKE '%10.90.18.115:7839%' OR URISTRING LIKE '%10.90.130.12:7939%' OR URISTRING LIKE '%10.90.130.34:7939%' OR URISTRING LIKE '%10.90.130.11:7839%' OR URISTRING LIKE '%10.218.15.52:7839%' OR URISTRING LIKE '%10.217.1.12:7839%' OR URISTRING LIKE '%10.90.82.103:7839%' OR URISTRING LIKE '%10.134.5.155:7839%' OR URISTRING LIKE '%10.90.130.36:7939%' OR URISTRING LIKE '%10.118.81.72:7839%' OR URISTRING LIKE '%10.90.130.33:7839%' OR URISTRING LIKE '%10.160.231.36:7839%' OR URISTRING LIKE '%10.124.96.1:7839%' OR URISTRING LIKE '%10.90.130.14:7939%' OR URISTRING LIKE '%10.172.78.42:7839%' OR URISTRING LIKE '%10.165.0.4:7839%') AND (ENTLEVEL=:1 OR ENTLEVEL=:2 OR ENTLEVEL=:3) AND ((COMMONNAME LIKE 'source_jb' AND PROCESSNAME IN('EXT_KA'))) ORDER BY SOURCETIMESTAMP DESC |
| fsbqktj5vw6n9 | select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1 |
| gcph0kd36arc6 | SELECT /*+ ORDERED PUSH_SUBQ */ DISTINCT D.PROFILE_NAME, D.DEVICE_NAME, D.TYPE, D.STATUS, D.PROGRAM, CFG.OWNER, CFG.RULE_NAME, DECODE(D.TYPE, :B29 , D.PROFILE_NAME, :B28 , D.PROFILE_NAME, CFG.OWNER) CHECKUSER FROM (SELECT RULE_NAME, OWNER FROM MGMT_NOTIFY_RULE_CONFIGS C WHERE ((:B26 LIKE C.TARGET_TYPE ESCAPE :B21 AND :B25 LIKE C.TARGET_NAME ESCAPE :B21 ) OR (C.TARGET_GUID IS NOT NULL AND EXISTS (SELECT 1 FROM MGMT_FLAT_TARGET_ASSOC A, MGMT_TARGETS T WHERE A.SOURCE_TARGET_GUID = C.TARGET_GUID AND A.IS_MEMBERSHIP = 1 AND A.ASSOC_TARGET_GUID = T.TARGET_GUID AND T.TARGET_TYPE = C.TARGET_TYPE AND T.TARGET_NAME = :B25 ))) AND :B24 LIKE C.METRIC_NAME ESCAPE :B21 AND :B23 LIKE C.METRIC_COLUMN ESCAPE :B21 AND ((:B22 LIKE C.KEY_VALUE ESCAPE :B21 ) OR (C.KEY_VALUE <> ' ' AND EXISTS (SELECT 1 FROM MGMT_METRICS_COMPOSITE_KEYS K WHERE K.COMPOSITE_KEY = :B22 AND NVL(K.KEY_PART1_VALUE, ' ') LIKE C.KEY_PART_1 ESCAPE :B21 AND NVL(K.KEY_PART2_VALUE, ' ') LIKE C.KEY_PART_2 ESCAPE :B21 AND NVL(K.KEY_PART3_VALUE, ' ') LIKE C.KEY_PART_3 ESCAPE :B21 AND NVL(K.KEY_PART4_VALUE, ' ') LIKE C.KEY_PART_4 ESCAPE :B21 AND NVL(K.KEY_PART5_VALUE, ' ') LIKE C.KEY_PART_5 ESCAPE :B21 AND K.TARGET_GUID = :B27 ))) AND ((:B4 = -1 AND ( (:B2 = :B20 AND WANT_TARGET_UNREACHABLE_START = 1) OR (:B2 = :B19 AND WANT_TARGET_UNREACHABLE_END = 1) OR (:B2 = :B18 AND WANT_TARGET_BLACKOUT_START = 1) OR (:B2 = :B17 AND WANT_TARGET_BLACKOUT_END = 1) OR (:B2 = :B16 AND ((WANT_TARGET_METRIC_ERR_START = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_START = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_START = 3))) OR (:B2 = :B15 AND ((WANT_TARGET_METRIC_ERR_END = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_END = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_END = 3))) OR (:B2 = :B1 AND WANT_CLEARS = 1 AND :B14 <> 1) OR (:B2 = :B1 AND WANT_TARGET_UP = 1 AND :B14 = 1) OR (:B2 = :B6 AND WANT_WARNINGS = 1) OR (:B2 = :B5 AND WANT_CRITICAL_ALERTS = 1 AND :B14 <> 1) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 0) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 1 AND :B11 NOT IN (:B10 , :B9 )) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 0 AND :B11 IN (:B10 , :B9 )) OR ((:B2 = :B8 OR :B2 = :B6 OR :B2 = :B5 ) AND WANT_POLICY_VIOLATIONS = 1 ) OR (:B2 = :B1 AND WANT_POLICY_CLEARS = 1 ) ) ) OR (:B4 <> -1 AND ( (:B4 = :B7 AND :B2 = :B6 AND WANT_WARNING_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 = :B5 AND WANT_CRITICAL_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 <> :B1 AND WANT_POLICY_JOB_SUCCEEDED = 1) OR (:B4 = :B3 AND :B2 = :B6 AND WANT_WARNING_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 = :B5 AND WANT_CRITICAL_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 <> :B1 AND WANT_POLICY_JOB_PROBLEMS = 1) ) ) )) CFG, MGMT_NOTIFY_NOTIFYEES N, MGMT_NOTIFY_DEVICES D WHERE N.RULE_NAME = CFG.RULE_NAME AND N.OWNER = CFG.OWNER AND ((D.DEVICE_NAME = N.DEVICE_NAME AND D.PROFILE_NAME = N.PROFILE_NAME) OR (N.DEVICE_NAME = ' ' AND D.PROFILE_NAME = N.PROFILE_NAME AND D.TYPE IN (:B29 , :B28 ) ) ) ORDER BY CHECKUSER |
| gg4q6xaj672f4 | DELETE FROM LogEntryB WHERE INSERTTIMESTAMP < :1 |