Enter value for report_name: awrrpt_1_1200_1500.html
Using the report name awrrpt_1_1200_1500.html
SQL Id | SQL Text |
00prz3j9n4gyj | SELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(COLLECTION_TIMESTAMP, 'HH24') |
05xcf43d9psvm | SELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES |
07c4n5uh9nk0r | select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYSMAN"."MGMT_TASK_QTABLE" tab where tab.msgid = :1 and tab.state != 2 for update skip locked |
089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL |
08bqjmf8490s2 | SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
08vznc16ycuag | SELECT SYS_GUID() FROM SYS.DUAL |
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') |
0xqn4sx1ytghr | select /*+ first_rows(1) no_expand */ tab.msgid from "SYSMAN"."AQ$_MGMT_TASK_QTABLE_F" tab where q_name = :1 and (state = :2 ) and queue_id = :3 and ( tab.user_data.scheduled_time <= CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) AND (tab.user_data.message_code = 0 OR tab.user_data.message_code = 1)) |
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) |
24dkx03u3rj6k | SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE' |
24g90qj2b7ywk | BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.process_wait_step(:2);END; EMDW_LOG.set_context; END; |
2b064ybzkwf1y | BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; |
2jfqzrxhrm93b | select /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# |
2mysbczfp729x | SELECT /*+ INDEX(ping mgmt_emd_ping_idx_01) */ TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND PING.TARGET_GUID = PINGC.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND PING.PING_JOB_NAME IS NULL AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)*24*60*60 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL |
34rks4d5suuxz | SELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(24*60*60) |
350myuyx0t1d6 |
insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
|
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) |
3mzmha5pxaf9j | SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM ( SELECT :B3 JOB_ID, :B3 EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE = :B2 AND STEP_STATUS != :B1 UNION SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 ) AND COMMAND_TYPE = :B5 AND START_TIME <= :B4 ) WHERE ROWNUM <= :B8 |
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 |
415urv6x9mf8w | SELECT /*+ RULE */ STEP_ID FROM MGMT_JOB_EXECUTION E, MGMT_JOB J WHERE E.JOB_ID=J.JOB_ID AND STEP_STATUS IN (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 ) AND STEP_TYPE=:B2 AND J.EXECUTION_TIMEOUT > 0 AND (:B1 -E.START_TIME) > (J.EXECUTION_TIMEOUT/24) |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
47a50dvdgnxc2 | update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4 |
4cwh3y70p6fdb |
select a.tablespace_name, a.meg, a.maxmeg, a.file_name, a.file_id, a.ts#, a.blocksize, a.flag, b.freebytes, b.maxfreebytes, nvl(c.ts#, -99) from (select f.tablespace_name, (f.bytes)/1048576 meg, (f.maxbytes)/1048576 maxmeg, f.file_name, f.file_id, ts.ts#, ts.blocksize, DECODE(BITAND(ts.flags, 3), 1, ts.dflminlen, 0) flag from sys.ts$ ts, sys.dba_data_files f where ts.contents$ = 0 and ts.online$ = 1 AND ( ts.bitmapped = 0 OR (ts.bitmapped != 0 AND bitand(ts.flags, 3) = 0)) AND bitand(flags, 2048) != 2048 and f.tablespace_name = ts.name) a, (SELECT ts.name tablespace_name, SUM(e.length * ts.blocksize/1048576) freebytes, MAX(e.length * ts.blocksize/1024) maxfreebytes FROM sys.fet$ e, sys.ts$ ts WHERE ts.ts# = e.ts# GROUP BY ts.name UNION ALL SELECT ts.name tablespace_name, SUM(e.blocks * ts.blocksize/1048576) freebytes, MAX(e.blocks * ts.blocksize/1024) maxfreebytes FROM sys.dba_lmt_free_space e, sys.ts$ ts WHERE ts.ts# = e.tablespace_id GROUP BY ts.name) b, (select d
istinct s.ts# from sys.seg$ s where s.maxexts < 2100000000 and s.maxexts - extents < 2 and exists (select 1 from sys.sys_objects so where so.header_block = s.block# and s.file# = so.header_file and s.ts# = so.ts_number)) c where a.tablespace_name = b.tablespace_name and a.ts# = c.ts#(+) order by a.tablespace_name, a.file_name |
4dy1xm4nxc0gf | insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id |
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), M
GMT_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, POL
ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC |
4nw0ag3rg25h1 | INSERT INTO mgmt_db_hdm_metric_helper(COLLECTION_TIMESTAMP, TARGET_GUID, TASK_AVAILABLE, TASK_COUNT) VALUES ( :1, :2, :3, :4) |
4vs91dcv7u1p6 | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36) |
5fk0v8km2f811 | select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance |
5k5v1ah25fb2c | BEGIN EMD_LOADER.UPDATE_CURRENT_METRICS(:1, :2, :3, :4, :5, :6); END; |
5kyb5bvnu3s04 | SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1 |
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 |
66gs90fyynks7 |
insert into wrh$_instance_recovery (snap_id, dbid, instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt) select :snap_id, :dbid, :instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt from v$instance_recovery
|
6k5agh28pr3wp | select propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name |
6r95ktyt1vgmg | SELECT CURRENT_STATUS FROM MGMT_CURRENT_AVAILABILITY WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B1 ) ORDER BY TARGET_GUID FOR UPDATE |
6v7n0y2bq89n8 | BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get_scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END; |
74fnxs1kfd150 | DELETE FROM MGMT_BLACKOUT_WINDOWS WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B4 ) AND END_TIME IS NOT NULL AND END_TIME < (:B3 - (1/24)) AND STATUS IN (:B2 , :B1 ) |
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 |
7av8js40455qb | SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B2 AND TARGET_TYPE = :B1 |
7d92gmwphtza8 | SELECT OWNER, JOB_NAME, COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_IDX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP' |
7hskd14849h8k | SELECT GREATEST(0, NVL(TRUNC(TO_NUMBER(VALUE)/60, 2), 0)) FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderOldestFile' AND HOST_URL = :B1 |
7mdacxfm37utk | SELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYS_EXTRACT_UTC(SYSTIMESTAMP)-LAST_TIME_STAMP_UTC > NUMTODSINTERVAL(HEARTBEAT_INTERVAL*:B1 , 'SECOND') |
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') |
7wt7phk4xns75 | select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status |
81ky0n97v4zsg | /* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select sid from v$mystat where rownum=1) |
84k66tf2s7y1c | insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id |
85snhhhd1qmt7 | SELECT NVL(TO_NUMBER(SUM(VALUE)), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME = 'EMD_NOTIFICATION.NotificationDelivery Subsystem' AND TIME > (SYSDATE-(1/(24*6))) AND HOST_URL = :B1 |
8b5vzx9k2t7s9 |
/* OracleOEM */ DECLARE TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; x clob := null; pos1 INTEGER := 1; pos2 INTEGER := 4000; statData clob := null; sizeData clob := null; objectsData clob := null; tmp VARCHAR2(4000); partitionName VARCHAR2(4000); jobName VARCHAR2(500); idx_name VARCHAR2(4000); part_name VARCHAR2(4000); tmp_str VARCHAR2(4000); guid RAW(16); idx_guid RAW(16); cursor idx_cur IS select owner, job_name, comments from dba_scheduler_jobs where job_name like 'EM_IDX_STAT_JOB%' and upper(owner) = 'DBSNMP'; idx_rec idx_cur%ROWTYPE; BEGIN OPEN idx_cur; FETCH idx_cur into idx_rec; guid := :1; IF idx_cur%FOUND THEN dbms_lob.createtemporary(statData, false); dbms_lob.createtemporary(sizeData, false); dbms_lob.createtemporary(objectsData, false); idx_name := substr(idx_rec.comments, 1, instr(idx_rec.comments, '|')-1); tmp_str := substr(idx_rec.comments, instr(idx_rec.comments, '|')+1); part_name := substr(tmp_str, 1, instr(tmp_str, '|')-1); idx_guid := substr(t
mp_str, instr(tmp_str, '|')+1); if guid = idx_guid THEN if part_name != 'null' then partitionName := part_name; end if; ctx_report.index_stats(idx_name, x, partitionName, true, 5); pos1 := dbms_lob.instr(x, 'indexed documents:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'allocated docids:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, '$I rows:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'unique tokens:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, p
os2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average $I rows per token:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average size per token:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average frequency per token:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'token type:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend
(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'unique tokens:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total rows:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average rows:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'averag
e size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average frequency:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total size of $I data:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'estimated row fragmentation:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'garbage docids:', pos1); IF pos1 > 0 THEN
pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'estimated garbage size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); dbms_lob.writeappend(statData, pos2-pos1, tmp); END IF; /*dbms_lob.freetemporary(x); */ /* Gather Index Objects Data */ ctx_report.describe_index(idx_name, x); pos1 := 1; pos1 := dbms_lob.instr(x, 'datastore:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'filter:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'section gr
oup:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'lexer:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'wordlist:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'stemmer:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'fuzzy_match:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1
); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'stoplist:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'storage:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; /* Gather Size Data */ ctx_report.index_size(idx_name, x, partitionName); pos1 := 1; LOOP pos1 := dbms_lob.instr(x, 'INDEX (', pos1); EXIT WHEN pos1 < 1; pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'TABLE NAME:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := d
bms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'TABLESPACE NAME:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BLOCKS ALLOCATED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BLOCKS USED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BYTES ALLOCATED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BYTES USED:', pos1); pos2 := dbms_lob.i
nstr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); END LOOP; OPEN data_cursor FOR SELECT idx_name, partitionName, dbms_lob.substr(statData), dbms_lob.substr(sizeData), dbms_lob.substr(objectsData) FROM DUAL; :2 := data_cursor; jobName := idx_rec.owner || '.' || idx_rec.job_name; dbms_scheduler.drop_job(job_name => jobName, force => true); dbms_lob.freetemporary(sizeData); dbms_lob.freetemporary(statData); dbms_lob.freetemporary(objectsData); dbms_lob.freetemporary(x); end if; ELSE OPEN data_cursor FOR select 'dummy', 'dummy', 'dummy', 'dummy', 'dummy' from dual; :2 := data_cursor; END IF; END; |
8p447s6p0rv6b | select java_pool_size_for_estimate s, java_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$java_pool_advice |
8t43xdhf4d9x2 | SELECT CONTEXT_TYPE_ID, CONTEXT_TYPE, TRACE_LEVEL, NULL, NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 ) |
8u5gujrwh4wf4 |
/* OracleOEM */ declare TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; cap_count number; apply_count number; propagation_count number; cap_error_count number; apply_error_count number; prop_error_count number; total_prop_errors number; sqlstmt varchar2(32767); begin SELECT COUNT(*) into cap_count FROM SYS.DBA_CAPTURE; SELECT COUNT(*) into apply_count FROM SYS.DBA_APPLY; SELECT COUNT(*) into propagation_count FROM SYS.DBA_PROPAGATION; SELECT COUNT(*) into cap_error_count FROM SYS.DBA_CAPTURE WHERE ERROR_NUMBER IS NOT NULL; SELECT COUNT(*) into apply_error_count FROM SYS.DBA_APPLY WHERE ERROR_NUMBER IS NOT NULL; SELECT COUNT(*) into prop_error_count FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL; SELECT NVL(SUM(FAILURES), 0) into total_prop_errors FROM SYS.DBA_QUEUE_SCHEDULES; sqlstmt := 'select '||cap_count||' CAPTURE_COUNT, '||apply_count||' APPLY_COUNT, '||propagation_count||' PROP_COUNT, '||cap_error_count||' CAPTURE_ERROR_COUNT, '||apply_error_coun
t||' APPLY_ERROR_COUNT, '||prop_error_count||' PROP_ERROR_COUNT, '||total_prop_errors||' TOTAL_PROP_ERRORS from dual'; OPEN data_cursor FOR sqlstmt; :1 := data_cursor; end; |
8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1 |
934ur8r7tqbjx | SELECT DBID FROM V$DATABASE |
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.nex
t_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.cla
ss_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 |
9juw6s4yy5pzp | /* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS ) |
9q910gyqj6w95 | DELETE FROM MGMT_JOB_HISTORY WHERE STEP_ID = :B1 |
9ugwm6xmvw06u | SELECT LAST_LOAD_TIME FROM MGMT_TARGETS WHERE TARGET_GUID=:B1 |
a5pyncg7v0bw3 | /* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%' |
ab5btgh76akb6 | delete from "SYSMAN"."MGMT_JOB_STEP_TARGETS" where "STEP_ID" = :1 |
aq8yqxyyb40nn | update sys.job$ set this_date=:1 where job=:2 |
auqc5yhb7ady2 | SELECT DISTINCT HOST_URL FROM MGMT_OMS_PARAMETERS WHERE NAME='TIMESTAMP' |
aykvshm7zsabd | select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3' |
b0d86bn8ncths | SELECT STEP_ID FROM MGMT_JOB_EXECUTION WHERE STEP_ID = :B1 FOR UPDATE NOWAIT |
b2u9kspucpqwy | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL |
bfujkg8dw1aax | SELECT UPPER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
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 |
bryu1pu7rnk2s | SELECT REPLACE(REPLACE(ddf.file_name, chr(10), ''), chr(13), '') "file_name", ddf.online_status "status", ddf.tablespace_name "tablespace_name", NVL(ddf.bytes, 0) "bytes", ddf.autoextensible "autoextensible", ddf.increment_by "increment_by", ddf.maxbytes "max_bytes" FROM sys.dba_data_files ddf |
btwkwwx56w4z6 | SELECT target_guid FROM mgmt_metric_dependency WHERE can_calculate = 1 AND event_metric = 1 AND disabled = 0 AND rs_metric = 1 ORDER BY eval_order |
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 |
c8h3jdwaa532q | SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
cn58bhkggqvj4 |
/* OracleOEM */ SELECT dtp.tablespace_name "TABLESPACE_NAME", dtp.status "STATUS", dtp.contents "CONTENTS", dtp.extent_management "EXTENT MANAGEMENT", dtp.allocation_type "ALLOCATION TYPE", dtp.logging "LOGGING", NVL(ts.bytes, 0) "SIZE (M)", dtp.initial_extent "INITIAL EXT SIZE (K)", dtp.next_extent "Next Extent", dtp.pct_increase "INCREMENT PCT", dtp.max_extents "MAX EXTENTS", NVL(ts.bytes - NVL(f.bytes, 0), 0) "USED BYTES", dtp.min_extents, dtp.min_extlen, dtp.segment_space_management "SEGMENT SPACE MANAGEMENT", dtp.block_size, dtp.bigfile FROM sys.dba_tablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) ts, (SELECT tablespace_name, sum(bytes) bytes from dba_free_space GROUP BY tablespace_name) f WHERE dtp.tablespace_name = ts.tablespace_name (+) AND dtp.tablespace_name = f.tablespace_
name (+) AND NOT (dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY') UNION ALL SELECT dtp.tablespace_name "TABLESPACE_NAME", dtp.status "STATUS", dtp.contents "CONTENTS", dtp.extent_management "EXTENT MANAGEMENT", dtp.allocation_type "ALLOCATION TYPE", dtp.logging "LOGGING", NVL(a.bytes, 0) "SIZE (M)", dtp.initial_extent "INITIAL EXT SIZE (K)", dtp.next_extent "Next Extent", dtp.pct_increase "INCREMENT PCT", dtp.max_extents "MAX EXTENTS", NVL(t.bytes, 0) "USED BYTES", dtp.min_extents, dtp.min_extlen, dtp.segment_space_management "SEGMENT SPACE MANAGEMENT", dtp.block_size, dtp.bigfile FROM sys.dba_tablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_temp_files GROUP BY tablespace_name) a, (select ss.tablespace_name , sum((ss.used_blocks*ts.blocksize)) bytes from gv$sort_segment ss, sys.ts$ ts where ss.ta
blespace_name = ts.name group by ss.tablespace_name) t WHERE dtp.tablespace_name = a.tablespace_name (+) AND dtp.tablespace_name = t.tablespace_name (+) AND dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY' |
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 |
cxjqbfn0d3yqq | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION |
cydnuss99swtd | BEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END; |
d27r7zhtnfgp4 | SELECT LAST_DATE, THIS_DATE FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();' |
dkk8923ygggj7 | UPDATE MGMT_EMD_PING SET LAST_HEARTBEAT_TS = :B6 , LAST_HEARTBEAT_UTC = CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE), CLEAN_HEARTBEAT_UTC = :B5 , STATUS_SYNC_UTC = :B4 , EMD_UPTIME_UTC = :B3 , HEARTBEAT_RECORDER_URL = SUBSTR(:B1 , 0, 256), UNRCH_START_TS = NULL WHERE TARGET_GUID = :B2 |
dwssdqx28tzf5 | select sysdate + 1 / (24 * 60) from dual |
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 |
fcg2mzztpyraq | UPDATE MGMT_METRICS_RAW SET VALUE= :1 WHERE METRIC_GUID= HEXTORAW(:2) AND COLLECTION_TIMESTAMP= :3 AND KEY_VALUE= NVL(:4, ' ') AND TARGET_GUID= HEXTORAW(:5) |
fjvwzpxbpch0h |
/* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STR
EAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator
c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name |
frky6qxh68bk7 | SELECT NVL(TO_NUMBER(VALUE), 0) FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderFileCount' AND HOST_URL = :B1 |
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 |
fsn35zyxmf1uy | SELECT WHAT, NEXT_DATE NEXT_TIME, DECODE(NVL(BROKEN, 'Y'), 'Y', 'DOWN', 'UP') BROKEN FROM USER_JOBS WHERE WHAT LIKE '%EXECUTE_EM_DBMS_JOB%' |
gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME) |
gwj1f651t001a | /* OracleOEM */ SELECT SEVERITY_INDEX, CRITICAL_INICDENTS, WARNING_INCIDENTS from v$incmeter_summary |