| SQL Id | SQL Text |
|---|
| 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 |
| 0pp7ymq1a9vgy | BEGIN proc_minus_order_tree(:1, :2, :3, :4, :5); END; |
| 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') |
| 1dqnujsswkgp4 | SELECT COUNT(1) FROM MI_TEMP_TREE T WHERE T.QTY_MEMBER=:B1 AND T.S_TYPE=0 |
| 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)) |
| 1xqp9sh20rqka | select * from ( select row_.*, rownum rownum_ from ( select a.*, b.right_no, case when a.order_type in(:"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03") then b.unit_fv else a.total_fv end fv from po_order a, po_order_right b, (select * from mi_member_right where link_index like :"SYS_B_04") c, mi_member m where a.id=b.order_id(+) and b.right_no=c.right_no and a.member_no=m.member_no and a.order_type not in(:"SYS_B_05", :"SYS_B_06") and nvl(a.cancel_Status, :"SYS_B_07")!=:"SYS_B_08" order by a.id desc, b.id asc ) row_ where rownum <= :"SYS_B_09") where rownum_ > :"SYS_B_10" |
| 2f3candgy4kxz | SELECT TIMEZONE_REGION , TARGET_TYPE, EMD_URL, MONITORING_MODE FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 |
| 2g0wsxgktu720 | SELECT RESULT_KEY_VALUE FROM MGMT_POLICY_ASSOC_EVAL_DETAILS WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1 AND RESULT_KEY_VALUE NOT IN (SELECT COLUMN_VALUE FROM TABLE(CAST(:B4 AS MGMT_MEDIUM_STRING_TABLE))) |
| 2k0979m1jmmww | select * from ( select d.goodscode, sum(d.quantity) from po_order r, po_order_detail d, bi_company_goods c where r.id=d.order_id and r.order_type in(8, 11) and r.companycode='PLW' and nvl(r.cancel_status, 0)=0 and r.status=1 and r.PAYMENT_METHOD=1 and r.check_time>sysdate-60 and c.companycode='PLW' and c.stop_sall=0 and d.goodscode=c.goodscode and c.is_exit=0 group by d.goodscode order by sum(d.quantity) desc ) where rownum<=5 |
| 2rq8p9b3f1n82 | SELECT COUNT(BROKEN) FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES' |
| 2wuxsvgst612h | SELECT NVL(AVG(VALUE), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME=:B2 AND NAME=:B1 AND TIME>(SYSDATE-(1/24)) |
| 35kddb5g8m1p7 | select * from ( select row_.*, rownum rownum_ from ( select r.*, nvl(b.bonus_amt, :"SYS_B_00") as bonus_amt, m.company_code, m.name, a.status, a.active_type, a.active_week, a.active_num from bd_bonus_his_right_change r left join mi_member m on m.member_no=r.member_no left join bd_bonus_his_mem a on a.member_no=r.member_no and a.w_week=r.w_week left join bd_bonus_his_sub b on b.recommend_no=r.right_no and b.w_week=r.w_week and b.bonus_item=:"SYS_B_01" where :"SYS_B_02"=:"SYS_B_03" and r.w_week >= :"SYS_B_04" and r.w_week <= :"SYS_B_05" and upper(m.agent_no) = :"SYS_B_06" and r.w_week >= :"SYS_B_07" and r.w_week <= :"SYS_B_08" ) row_ where rownum <= :"SYS_B_09") where rownum_ > :"SYS_B_10" |
| 3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln |
| 3gxktncfpsm0d | SELECT TARGET_GUID FROM MGMT_CURRENT_AVAILABILITY WHERE TARGET_GUID = :B1 FOR UPDATE |
| 3txsz462t827r | select t.* , case when consume_pv_active_week is not null and consume_pv_active_week > rem_active_week then consume_pv_active_week + pv_pv_active_week else case when rem_active_week < :"SYS_B_00" then :"SYS_B_01" else rem_active_week + pv_pv_active_week end end final_active_week from( select a.member_no, a.name, a.agent_no, a.company_code, a.card_type, a.register_date, a.active_time , b.active_week, nvl(b.active_num, :"SYS_B_02") as rem_active_week, :"SYS_B_03" as curr_week , c.valid_balance , d.end_week , case when nvl(c.valid_balance, :"SYS_B_04")<:"SYS_B_05" then :"SYS_B_06" else trunc(c.valid_balance/:"SYS_B_07", :"SYS_B_08")*:"SYS_B_09" end pv_pv_active_week , case when d.end_week is not null then (to_date(:"SYS_B_10"||end_week, :"SYS_B_11")-to_date(:"SYS_B_12"||:"SYS_B_13", :"SYS_B_14"))/:"SYS_B_15" + :"SYS_B_16" end consume_pv_active_week from mi_member a left join v_bd_bonus_mem b on b.member_no=a.member_no and b.w_week=:"SYS_B_17" left join fi_ac_balance c on c.user_code=a.member_no and c.ac_type=:"SYS_B_18" left join (select d2.member_no, max(d1.end_week) end_week from po_consum_week d1 left join po_consum_order d2 on d2.id=d1.order_id where :"SYS_B_19"=:"SYS_B_20" group by d2.member_no) d on d.member_no=a.member_no where :"SYS_B_21"=:"SYS_B_22") t where :"SYS_B_23"=:"SYS_B_24" and upper(member_no) = :"SYS_B_25" |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 45tg25j85snzc | SELECT VIOLATION_LEVEL, COLLECTION_TIMESTAMP FROM (SELECT VIOLATION_LEVEL, COLLECTION_TIMESTAMP FROM MGMT_VIOLATIONS, (SELECT MAX(COLLECTION_TIMESTAMP) AS MAX_TS FROM MGMT_VIOLATIONS WHERE TARGET_GUID = :B5 AND POLICY_GUID = :B4 AND KEY_VALUE = :B3 AND COLLECTION_TIMESTAMP > :B2 AND COLLECTION_TIMESTAMP <= :B1 ) TS WHERE TARGET_GUID = :B5 AND POLICY_GUID = :B4 AND KEY_VALUE = :B3 AND COLLECTION_TIMESTAMP = TS.MAX_TS ORDER BY DECODE(VIOLATION_LEVEL, :B11 , 1, :B10 , 2, :B9 , 3, :B8 , 4, :B7 , 5, :B6 , 6, 9)) WHERE ROWNUM = 1 |
| 45wng0c0dnbmw | UPDATE MGMT_LAST_VIOLATION SET COLLECTION_TIMESTAMP = :B2 WHERE ROWID = :B1 |
| 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 |
| 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 |
| 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 |
| 4qmuqa3736uwd | select * from ( select mimember0_.ID as ID178_, mimember0_.ACCOUNT_BANK as ACCOUNT2_178_, mimember0_.ACCOUNT_CODE as ACCOUNT3_178_, mimember0_.ACCOUNT_NAME as ACCOUNT4_178_, mimember0_.ACTIVE_WEEK as ACTIVE5_178_, mimember0_.AGENT_NO as AGENT6_178_, mimember0_.BIRTHDAY as BIRTHDAY178_, mimember0_.CARD_TYPE as CARD8_178_, mimember0_.COMPANY_CODE as COMPANY9_178_, mimember0_.DIS_TYPE as DIS10_178_, mimember0_.EMAIL as EMAIL178_, mimember0_.EXIT_STATUS as EXIT12_178_, mimember0_.EXIT_TIME as EXIT13_178_, mimember0_.EXIT_USER as EXIT14_178_, mimember0_.FAX as FAX178_, mimember0_.HEALTHY as HEALTHY178_, mimember0_.HOME_TEL as HOME17_178_, mimember0_.IS_FREE as IS18_178_, mimember0_.IS_MALL as IS19_178_, mimember0_.KNOW_WAY as KNOW20_178_, mimember0_.MEM_TYPE as MEM21_178_, mimember0_.MEMBER_NO as MEMBER22_178_, mimember0_.MOBILE as MOBILE178_, mimember0_.NAME as NAME178_, mimember0_.OFFICE_TEL as OFFICE25_178_, mimember0_.PAPER_NO as PAPER26_178_, mimember0_.PAPER_TYPE as PAPER27_178_, mimember0_.PERIOD_WEEK as PERIOD28_178_, mimember0_.PET_NAME as PET29_178_, mimember0_.RECOMMEND_NO as RECOMMEND30_178_, mimember0_.REGION_CODE as REGION31_178_, mimember0_.REGISTER_DATE as REGISTER32_178_, mimember0_.REMARK as REMARK178_, mimember0_.SEX as SEX178_, mimember0_.STORE_ADDR as STORE35_178_, mimember0_.STORE_ID as STORE36_178_, mimember0_.STORE_POST as STORE37_178_, mimember0_.WEB_ADDR as WEB38_178_ from MI_MEMBER mimember0_ where upper(mimember0_.MEMBER_NO)=:"SYS_B_0" ) where rownum <= :1 |
| 4yy9rqdnwwuak | select nvl(count(case when s.bonus_type=:"SYS_B_00" then p.id end), :"SYS_B_01") as dconut, nvl(sum(case when s.bonus_type=:"SYS_B_02" then p.total_fv else :"SYS_B_03" end ), :"SYS_B_04") as dtotalAmount , nvl(count(case when s.bonus_type=:"SYS_B_05" then p.id end), :"SYS_B_06") as econut, nvl(sum(case when s.bonus_type=:"SYS_B_07" then p.total_fv else :"SYS_B_08" end ), :"SYS_B_09") as etotalAmount from po_order p left join sys_company s on p.companycode = s.company_code where :"SYS_B_10" = :"SYS_B_11" and nvl(p.cancel_status, :"SYS_B_12") = :"SYS_B_13" and p.order_type in(:"SYS_B_14") and p.companycode=:"SYS_B_15" and p.period_week=:"SYS_B_16" |
| 520mkxqpf15q8 | select 1 from dual |
| 54fqjq6fpmts6 | SELECT MGMT_GLOBAL.SYSDATE_TZRGN(TIMEZONE_REGION), TARGET_NAME FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 |
| 5mw55dp9p6nyt | select nvl(max(al.recid), '0'), nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where al.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN' |
| 5sj50rwnwh26f | UPDATE MGMT_VIOLATIONS SET VIOLATION_DURATION = (:B1 - :B3 ) * 24 WHERE VIOLATION_GUID = :B2 |
| 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 |
| 61tn3mam0vq0b | SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC |
| 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; |
| 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 |
| 7f5pj3jtqavnn | SELECT A.DATABASE_TIME, ( CAST(A.END_TIME AS DATE) - CAST(A.BEGIN_TIME AS DATE) ) * 86400, A.ACTUAL_ANALYSIS, A.PERC_FLUSH_TIME FROM WRI$_ADV_ADDM_TASKS A WHERE A.TASK_ID = :B1 |
| 7g732rx16j8jc | insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash |
| 7spm0c69n6wrh | select * from ( select mimemberri0_.ID as ID166_, mimemberri0_.ACTIVE_DATE as ACTIVE2_166_, mimemberri0_.CANNO_LINK as CANNO3_166_, mimemberri0_.CICLES as CICLES166_, mimemberri0_.CREATE_TIME as CREATE5_166_, mimemberri0_.LEFT_MEM as LEFT6_166_, mimemberri0_.LEFT_POINT as LEFT7_166_, mimemberri0_.LEVEL_TYPE as LEVEL8_166_, mimemberri0_.LINK_INDEX as LINK9_166_, mimemberri0_.LINK_LAYER as LINK10_166_, mimemberri0_.LINK_NO as LINK11_166_, mimemberri0_.MEMBER_NO as MEMBER12_166_, mimemberri0_.PRIM_RIGHT as PRIM13_166_, mimemberri0_.PV as PV166_, mimemberri0_.PV_LIMIT as PV15_166_, mimemberri0_.RIGHT_MEM as RIGHT16_166_, mimemberri0_.RIGHT_NO as RIGHT17_166_, mimemberri0_.RIGHT_POINT as RIGHT18_166_, mimemberri0_.STAGE as STAGE166_ from MI_MEMBER_RIGHT mimemberri0_ where upper(mimemberri0_.RIGHT_NO)=:"SYS_B_0" ) where rownum <= :1 |
| 7x423fgjpmpyj | select count(:"SYS_B_00") from (select a.* , a.bonus_fund1+a.bonus_fund2+a.bonus_fund3+a.bonus_fund4 bonus_fund , b.area_code as area_code, c.name as company_name, d.name as area_name , case when (a.is_mall = :"SYS_B_01" and a.freeze_status <> :"SYS_B_02") then :"SYS_B_03" else a.freeze_status end as bonus_send_way , case when a.freeze_status = :"SYS_B_04" then nvl(a.bonus_circle, :"SYS_B_05")+nvl(a.bonus_recommend, :"SYS_B_06")+nvl(a.bonus_active, :"SYS_B_07") +nvl(a.bonus_act_guid, :"SYS_B_08")+nvl(a.bonus_lucky, :"SYS_B_09")+nvl(a.bonus_retail, :"SYS_B_10") else a.bonus_h0 end as bonus_fact_send , e.currency_code, e.rate, f.currency_name , case when a.bonus_type=:"SYS_B_11" then f.rate_to_eur when a.bonus_type=:"SYS_B_12" then f.rate_to_usd end curr_rate from bd_bonus_his_mem a left join sys_area_company b on b.company_code=a.company_code left join sys_company c on c.company_code = a.company_code left join sys_company d on d.company_code=b.area_code left join bd_bonus_his_agent e on e.agent_no=a.agent_no and e.w_week=a.w_week left join al_currency f on f.currency_code=e.currency_code where :"SYS_B_13"=:"SYS_B_14" and a.bonus_all > :"SYS_B_15" and upper(a.member_no) = :"SYS_B_16" and a.w_week >= :"SYS_B_17" order by a.id desc) |
| 7zv0mgby4ypst | SELECT A.* , B.LEFT_POINT, B.RIGHT_POINT, B.LEVEL_TYPE FROM (SELECT R.*, LEVEL LEVEL_NUM FROM (SELECT * FROM MI_TEMP_TREE R WHERE STATUS = 1 AND QTY_MEMBER = :B1 AND S_TYPE = 0) R START WITH RIGHT_NO = :B2 CONNECT BY PRIOR RIGHT_NO = LINK_NO ) A LEFT JOIN MI_MEMBER_RIGHT B ON A.RIGHT_NO=B.RIGHT_NO WHERE A.LEVEL_NUM<=:B3 ORDER BY LEVEL_NUM |
| 86fusfyn54btm | SELECT TARGET_TYPE, TARGET_NAME, TIMEZONE_REGION, BROKEN_REASON FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 |
| 8c72f6ux4tvt5 | select sum(nvl(case when a.order_type in(:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3") then b.unit_fv else a.total_fv end, :"SYS_B_4")) total_fv from po_order a, po_order_right b, (select * from mi_member_right where link_index like :"SYS_B_5") c, mi_member m where a.id=b.order_id(+) and b.right_no=c.right_no and a.member_no=m.member_no and a.order_type not in(:"SYS_B_6", :"SYS_B_7") and nvl(a.cancel_Status, :"SYS_B_8")!=:"SYS_B_9" |
| 8x0funf899dka | INSERT INTO wri$_adv_addm_inst ( TASK_ID, INSTANCE_NUMBER, INSTANCE_NAME, HOST_NAME, STATUS, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, METER_LEVEL, LOCAL_TASK_ID) VALUES ( :tid, :inst_num, :inst_name, :host_name, :st, NULL, NULL, NULL, NULL, NULL) |
| 99zgubwpmt6du | select a.link_no, a.left_mem, a.right_mem, a.right_no, a.link_layer-to_number(:"SYS_B_0")as link_layer, a.level_type , to_char(b.register_date, :"SYS_B_1") as register_date, to_char(a.create_time, :"SYS_B_2") as create_time, b.member_no, b.name, b.pet_name, a.link_index from MI_MEMBER_RIGHT a left join Mi_Member b on a.member_no=b.member_no where a.link_index like :"SYS_B_3" and a.link_layer <= :"SYS_B_4" order by a.link_layer, a.LINK_INDEX |
| 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 |
| 9g7a43gqdap1t | insert into WRH$_PERSISTENT_QUEUES (snap_id, dbid, instance_number, queue_schema, queue_name, queue_id, first_activity_time, enqueued_msgs, dequeued_msgs, browsed_msgs, elapsed_enqueue_time, elapsed_dequeue_time, enqueue_cpu_time, dequeue_cpu_time, avg_msg_age, dequeued_msg_latency, elapsed_transformation_time, elapsed_rule_evaluation_time, enqueued_expiry_msgs, enqueued_delay_msgs, msgs_made_expired, msgs_made_ready, last_enqueue_time, last_dequeue_time, last_tm_expiry_time, last_tm_ready_time, enqueue_transactions, dequeue_transactions, execution_count) select * from (select :snap_id, :dbid, :instance_number, qs.queue_schema, qs.queue_name, qs.queue_id, qs.first_activity_time, qs.enqueued_msgs, qs.dequeued_msgs, qs.browsed_msgs, qs.elapsed_enqueue_time, qs.elapsed_dequeue_time, qs.enqueue_cpu_time, qs.dequeue_cpu_time, qs.avg_msg_age, qs.dequeued_msg_latency, qs.elapsed_transformation_time, qs.elapsed_rule_evaluation_time, qs.enqueued_expiry_msgs, qs.enqueued_delay_msgs, qs.msgs_made_expired, qs.msgs_made_ready, qs.last_enqueue_time, qs.last_dequeue_time, qs.last_tm_expiry_time, qs.last_tm_ready_time, qs.enqueue_transactions, qs.dequeue_transactions, qs.execution_count from v$persistent_queues qs order by qs.enqueued_msgs desc) where rownum <= 25 |
| 9yt4ka3n2svmc | update sys.scheduler$_job set last_enabled_time = :1, next_run_date = :2, job_status = :3 where obj# = :4 |
| adm3ba32apxjg | select * from ( select sysvisitlo0_.LOG_ID as LOG1_119_, sysvisitlo0_.MODULE_CODE as MODULE2_119_, sysvisitlo0_.QUERY_STRING as QUERY3_119_, sysvisitlo0_.USER_CODE as USER4_119_, sysvisitlo0_.VISIT_TIME as VISIT5_119_, sysvisitlo0_.VISIT_URL as VISIT6_119_ from SYS_VISIT_LOG sysvisitlo0_ where sysvisitlo0_.USER_CODE=:"SYS_B_0" and sysvisitlo0_.MODULE_CODE=:"SYS_B_1" and sysvisitlo0_.VISIT_URL=:"SYS_B_2" ) where rownum <= :1 |
| afs7xvpbqcjmz | SELECT TARGET_NAME , TARGET_TYPE FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 |
| aq8yqxyyb40nn | update sys.job$ set this_date=:1 where job=:2 |
| b0320g1xasbx7 | SELECT TIMEZONE_REGION FROM MGMT_TARGETS WHERE TARGET_GUID = :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 |
| 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 |
| c54wcsn03mwka | select count(:"SYS_B_0") from (select r.*, nvl(b.bonus_amt, :"SYS_B_1") as bonus_amt, m.company_code, m.name, a.status, a.active_type, a.active_week, a.active_num from bd_bonus_his_right_change r left join mi_member m on m.member_no=r.member_no left join bd_bonus_his_mem a on a.member_no=r.member_no and a.w_week=r.w_week left join bd_bonus_his_sub b on b.recommend_no=r.right_no and b.w_week=r.w_week and b.bonus_item=:"SYS_B_2" where :"SYS_B_3"=:"SYS_B_4" and r.w_week >= :"SYS_B_5" and r.w_week <= :"SYS_B_6" and upper(r.member_no) = :"SYS_B_7") |
| canqma0jsduvm | select * from ( select row_.*, rownum rownum_ from ( select r.*, nvl(b.bonus_amt, :"SYS_B_0") as bonus_amt, m.company_code, m.name, a.status, a.active_type, a.active_week, a.active_num from bd_bonus_his_right_change r left join mi_member m on m.member_no=r.member_no left join bd_bonus_his_mem a on a.member_no=r.member_no and a.w_week=r.w_week left join bd_bonus_his_sub b on b.recommend_no=r.right_no and b.w_week=r.w_week and b.bonus_item=:"SYS_B_1" where :"SYS_B_2"=:"SYS_B_3" and r.w_week >= :"SYS_B_4" and r.w_week <= :"SYS_B_5" and upper(r.member_no) = :"SYS_B_6" ) row_ where rownum <= :"SYS_B_7") where rownum_ > :"SYS_B_8" |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 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 |
| dwvtx48mzp83d | select * from ( select row_.*, rownum rownum_ from ( select r.*, m.name as member_name, m.recommend_no, a.agent_no as agent_no, a.name as agent_name, c.company_code as company_code, c.name as company_name from mi_member_right r left join mi_member m on r.member_no = m.member_no left join mi_agent a on m.agent_no = a.agent_no left join sys_area_company e on m.company_code = e.company_code left join sys_company c on e.company_code = c.company_code where :"SYS_B_0"=:"SYS_B_1" and c.company_code=:"SYS_B_2" and upper(r.member_no) = :"SYS_B_3" order by r.prim_right desc, r.right_no asc ) row_ where rownum <= :"SYS_B_4") where rownum_ > :"SYS_B_5" |
| g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
| g6r4u7hadfr9t | select count(:"SYS_B_0") from (select a.*, b.right_no, case when a.order_type in(:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4") then b.unit_fv else a.total_fv end fv from po_order a, po_order_right b, (select * from mi_member_right where link_index like :"SYS_B_5") c, mi_member m where a.id=b.order_id(+) and b.right_no=c.right_no and a.member_no=m.member_no and a.order_type not in(:"SYS_B_6", :"SYS_B_7") and nvl(a.cancel_Status, :"SYS_B_8")!=:"SYS_B_9" order by a.id desc, b.id asc) |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO (space) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 0 | 0.00 | 0.00 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 0 | 0.00 | 0.00 |
| Batched IO same unit count | 0 | 0.00 | 0.00 |
| Batched IO single block count | 0 | 0.00 | 0.00 |
| Batched IO slow jump count | 0 | 0.00 | 0.00 |
| Batched IO vector block count | 0 | 0.00 | 0.00 |
| Batched IO vector read count | 0 | 0.00 | 0.00 |
| Block Cleanout Optim referenced | 37 | 0.01 | 0.04 |
| CCursor + sql area evicted | 2 | 0.00 | 0.00 |
| CPU used by this session | 4,752 | 1.32 | 5.26 |
| CPU used when call started | 3,720 | 1.03 | 4.12 |
| CR blocks created | 37 | 0.01 | 0.04 |
| Cached Commit SCN referenced | 1,395 | 0.39 | 1.54 |
| Clusterwide global transactions | 0 | 0.00 | 0.00 |
| Commit SCN cached | 8 | 0.00 | 0.01 |
| DB time | 427,040 | 118.45 | 472.39 |
| DBWR checkpoint buffers written | 1,414 | 0.39 | 1.56 |
| DBWR checkpoints | 1 | 0.00 | 0.00 |
| DBWR fusion writes | 193 | 0.05 | 0.21 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 93 | 0.03 | 0.10 |
| DBWR undo block writes | 348 | 0.10 | 0.38 |
| DFO trees parallelized | 34 | 0.01 | 0.04 |
| DX/BB enqueue lock background get time | 0 | 0.00 | 0.00 |
| DX/BB enqueue lock background gets | 0 | 0.00 | 0.00 |
| DX/BB enqueue lock foreground requests | 0 | 0.00 | 0.00 |
| DX/BB enqueue lock foreground wait time | 0 | 0.00 | 0.00 |
| Effective IO time | 126,763 | 35.16 | 140.22 |
| HSC Heap Segment Block Changes | 2,898 | 0.80 | 3.21 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 147 | 0.04 | 0.16 |
| Heap Segment Array Updates | 6 | 0.00 | 0.01 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 156 | 0.04 | 0.17 |
| PX local messages recv'd | 64 | 0.02 | 0.07 |
| PX local messages sent | 64 | 0.02 | 0.07 |
| PX remote messages recv'd | 392 | 0.11 | 0.43 |
| PX remote messages sent | 384 | 0.11 | 0.42 |
| Parallel operations not downgraded | 34 | 0.01 | 0.04 |
| Requests to/from client | 26,067 | 7.23 | 28.84 |
| RowCR - row contention | 0 | 0.00 | 0.00 |
| RowCR attempts | 361 | 0.10 | 0.40 |
| RowCR hits | 361 | 0.10 | 0.40 |
| SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
| SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 26,088 | 7.24 | 28.86 |
| active txn count during cleanout | 90 | 0.02 | 0.10 |
| application wait time | 4 | 0.00 | 0.00 |
| background checkpoints completed | 0 | 0.00 | 0.00 |
| background checkpoints started | 1 | 0.00 | 0.00 |
| background timeouts | 28,612 | 7.94 | 31.65 |
| branch node splits | 0 | 0.00 | 0.00 |
| buffer is not pinned count | 828,980 | 229.94 | 917.01 |
| buffer is pinned count | 15,897,752 | 4,409.76 | 17,586.01 |
| bytes received via SQL*Net from client | 4,960,260 | 1,375.89 | 5,487.01 |
| bytes sent via SQL*Net to client | 6,171,796 | 1,711.95 | 6,827.21 |
| calls to get snapshot scn: kcmgss | 28,771 | 7.98 | 31.83 |
| calls to kcmgas | 4,930 | 1.37 | 5.45 |
| calls to kcmgcs | 8,720 | 2.42 | 9.65 |
| cell physical IO interconnect bytes | 398,072,320 | 110,418.30 | 440,345.49 |
| change write time | 16 | 0.00 | 0.02 |
| cleanout - number of ktugct calls | 104 | 0.03 | 0.12 |
| cleanouts and rollbacks - consistent read gets | 0 | 0.00 | 0.00 |
| cleanouts only - consistent read gets | 10 | 0.00 | 0.01 |
| cluster key scan block gets | 2,316 | 0.64 | 2.56 |
| cluster key scans | 2,065 | 0.57 | 2.28 |
| cluster wait time | 119 | 0.03 | 0.13 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 53 | 0.01 | 0.06 |
| commit batch/immediate requested | 53 | 0.01 | 0.06 |
| commit cleanout failures: block lost | 21 | 0.01 | 0.02 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 4 | 0.00 | 0.00 |
| commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
| commit cleanouts | 3,447 | 0.96 | 3.81 |
| commit cleanouts successfully completed | 3,422 | 0.95 | 3.79 |
| commit immediate performed | 53 | 0.01 | 0.06 |
| commit immediate requested | 53 | 0.01 | 0.06 |
| commit txn count during cleanout | 66 | 0.02 | 0.07 |
| concurrency wait time | 217 | 0.06 | 0.24 |
| consistent changes | 89 | 0.02 | 0.10 |
| consistent gets | 2,432,860 | 674.83 | 2,691.22 |
| consistent gets - examination | 722,851 | 200.51 | 799.61 |
| consistent gets direct | 204 | 0.06 | 0.23 |
| consistent gets from cache | 2,432,656 | 674.78 | 2,690.99 |
| consistent gets from cache (fastpath) | 1,703,163 | 472.43 | 1,884.03 |
| cursor authentications | 31 | 0.01 | 0.03 |
| data blocks consistent reads - undo records applied | 74 | 0.02 | 0.08 |
| db block changes | 18,558 | 5.15 | 20.53 |
| db block gets | 17,620 | 4.89 | 19.49 |
| db block gets direct | 30 | 0.01 | 0.03 |
| db block gets from cache | 17,590 | 4.88 | 19.46 |
| db block gets from cache (fastpath) | 4,930 | 1.37 | 5.45 |
| deferred (CURRENT) block cleanout applications | 1,854 | 0.51 | 2.05 |
| dirty buffers inspected | 0 | 0.00 | 0.00 |
| enqueue conversions | 1,141 | 0.32 | 1.26 |
| enqueue deadlocks | 0 | 0.00 | 0.00 |
| enqueue releases | 56,354 | 15.63 | 62.34 |
| enqueue requests | 56,368 | 15.64 | 62.35 |
| enqueue timeouts | 10 | 0.00 | 0.01 |
| enqueue waits | 302 | 0.08 | 0.33 |
| exchange deadlocks | 0 | 0.00 | 0.00 |
| execute count | 24,703 | 6.85 | 27.33 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io service time | 0 | 0.00 | 0.00 |
| file io wait time | 1,265,416 | 351.00 | 1,399.80 |
| flashback cache read optimizations for block new | 0 | 0.00 | 0.00 |
| flashback direct read optimizations for block new | 0 | 0.00 | 0.00 |
| flashback log write bytes | 10,829,824 | 3,004.00 | 11,979.89 |
| flashback log writes | 174 | 0.05 | 0.19 |
| free buffer inspected | 967 | 0.27 | 1.07 |
| free buffer requested | 1,855 | 0.51 | 2.05 |
| gc blocks compressed | 909 | 0.25 | 1.01 |
| gc blocks lost | 0 | 0.00 | 0.00 |
| gc cr block flush time | 4 | 0.00 | 0.00 |
| gc cr block receive time | 38 | 0.01 | 0.04 |
| gc cr blocks received | 800 | 0.22 | 0.88 |
| gc cr blocks served | 810 | 0.22 | 0.90 |
| gc current block flush time | 10 | 0.00 | 0.01 |
| gc current block pin time | 0 | 0.00 | 0.00 |
| gc current block receive time | 47 | 0.01 | 0.05 |
| gc current blocks received | 743 | 0.21 | 0.82 |
| gc current blocks served | 846 | 0.23 | 0.94 |
| gc kbytes saved | 4,371 | 1.21 | 4.84 |
| gc kbytes sent | 8,878 | 2.46 | 9.82 |
| gc local grants | 84 | 0.02 | 0.09 |
| gc read wait time | 0 | 0.00 | 0.00 |
| gc read wait timeouts | 0 | 0.00 | 0.00 |
| gc read waits | 0 | 0.00 | 0.00 |
| gc remote grants | 454 | 0.13 | 0.50 |
| gcs messages sent | 5,996 | 1.66 | 6.63 |
| ges messages sent | 2,939 | 0.82 | 3.25 |
| global enqueue get time | 51 | 0.01 | 0.06 |
| global enqueue gets async | 167 | 0.05 | 0.18 |
| global enqueue gets sync | 19,999 | 5.55 | 22.12 |
| global enqueue releases | 19,635 | 5.45 | 21.72 |
| heap block compress | 82 | 0.02 | 0.09 |
| hot buffers moved to head of LRU | 40 | 0.01 | 0.04 |
| immediate (CR) block cleanout applications | 10 | 0.00 | 0.01 |
| immediate (CURRENT) block cleanout applications | 702 | 0.19 | 0.78 |
| in call idle wait time | 18,295,844 | 5,074.95 | 20,238.77 |
| index crx upgrade (positioned) | 426 | 0.12 | 0.47 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 34 | 0.01 | 0.04 |
| index fetch by key | 382,912 | 106.21 | 423.58 |
| index scans kdiixs1 | 21,493 | 5.96 | 23.78 |
| leaf node 90-10 splits | 35 | 0.01 | 0.04 |
| leaf node splits | 45 | 0.01 | 0.05 |
| lob reads | 71 | 0.02 | 0.08 |
| lob writes | 74 | 0.02 | 0.08 |
| lob writes unaligned | 74 | 0.02 | 0.08 |
| logical read bytes from cache | 20,072,415,232 | 5,567,736.87 | 22,203,999.15 |
| logons cumulative | 437 | 0.12 | 0.48 |
| max cf enq hold time | 30 | 0.01 | 0.03 |
| messages received | 3,098 | 0.86 | 3.43 |
| messages sent | 3,098 | 0.86 | 3.43 |
| min active SCN optimization applied on CR | 0 | 0.00 | 0.00 |
| no buffer to keep pinned count | 1 | 0.00 | 0.00 |
| no work - consistent read gets | 1,696,131 | 470.48 | 1,876.25 |
| non-idle wait count | 158,887 | 44.07 | 175.76 |
| non-idle wait time | 2,058 | 0.57 | 2.28 |
| opened cursors cumulative | 23,502 | 6.52 | 26.00 |
| parse count (describe) | 2 | 0.00 | 0.00 |
| parse count (failures) | 0 | 0.00 | 0.00 |
| parse count (hard) | 56 | 0.02 | 0.06 |
| parse count (total) | 6,168 | 1.71 | 6.82 |
| parse time cpu | 88 | 0.02 | 0.10 |
| parse time elapsed | 102 | 0.03 | 0.11 |
| physical read IO requests | 269 | 0.07 | 0.30 |
| physical read bytes | 2,785,280 | 772.59 | 3,081.06 |
| physical read total IO requests | 12,152 | 3.37 | 13.44 |
| physical read total bytes | 264,077,312 | 73,250.43 | 292,120.92 |
| physical read total multi block requests | 99 | 0.03 | 0.11 |
| physical reads | 340 | 0.09 | 0.38 |
| physical reads cache | 106 | 0.03 | 0.12 |
| physical reads cache prefetch | 0 | 0.00 | 0.00 |
| physical reads direct | 234 | 0.06 | 0.26 |
| physical reads direct (lob) | 204 | 0.06 | 0.23 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads for flashback new | 92 | 0.03 | 0.10 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 1,246 | 0.35 | 1.38 |
| physical write bytes | 13,041,664 | 3,617.53 | 14,426.62 |
| physical write total IO requests | 4,229 | 1.17 | 4.68 |
| physical write total bytes | 62,295,040 | 17,279.55 | 68,910.44 |
| physical write total multi block requests | 51 | 0.01 | 0.06 |
| physical writes | 1,592 | 0.44 | 1.76 |
| physical writes direct | 30 | 0.01 | 0.03 |
| physical writes direct (lob) | 1 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 1,562 | 0.43 | 1.73 |
| physical writes non checkpoint | 412 | 0.11 | 0.46 |
| pinned buffers inspected | 0 | 0.00 | 0.00 |
| pinned cursors current | 5 | 0.00 | 0.01 |
| prefetch clients - default | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
| process last non-idle time | 1,921 | 0.53 | 2.13 |
| queries parallelized | 34 | 0.01 | 0.04 |
| recovery blocks read | 0 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 96,176 | 26.68 | 106.39 |
| recursive cpu usage | 1,155 | 0.32 | 1.28 |
| redo KB read | 11,663 | 3.24 | 12.90 |
| redo blocks checksummed by FG (exclusive) | 3,674 | 1.02 | 4.06 |
| redo blocks read for recovery | 0 | 0.00 | 0.00 |
| redo blocks written | 10,021 | 2.78 | 11.09 |
| redo buffer allocation retries | 1 | 0.00 | 0.00 |
| redo entries | 10,762 | 2.99 | 11.90 |
| redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
| redo log space requests | 2 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 258 | 0.07 | 0.29 |
| redo size | 4,561,488 | 1,265.28 | 5,045.89 |
| redo size for direct writes | 246,840 | 68.47 | 273.05 |
| redo subscn max counts | 601 | 0.17 | 0.66 |
| redo synch long waits | 2 | 0.00 | 0.00 |
| redo synch time | 39 | 0.01 | 0.04 |
| redo synch time (usec) | 435,188 | 120.71 | 481.40 |
| redo synch writes | 425 | 0.12 | 0.47 |
| redo wastage | 404,388 | 112.17 | 447.33 |
| redo write broadcast ack count | 93 | 0.03 | 0.10 |
| redo write broadcast ack time | 21,837 | 6.06 | 24.16 |
| redo write broadcast lgwr post count | 0 | 0.00 | 0.00 |
| redo write time | 135 | 0.04 | 0.15 |
| redo writes | 1,488 | 0.41 | 1.65 |
| remote Oradebug requests | 0 | 0.00 | 0.00 |
| rollback changes - undo records applied | 196 | 0.05 | 0.22 |
| rollbacks only - consistent read gets | 37 | 0.01 | 0.04 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 273,309 | 75.81 | 302.33 |
| scheduler wait time | 0 | 0.00 | 0.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 17,221 | 4.78 | 19.05 |
| session logical reads | 2,450,480 | 679.72 | 2,710.71 |
| shared hash latch upgrades - no wait | 4,723 | 1.31 | 5.22 |
| shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 11,098 | 3.08 | 12.28 |
| sorts (rows) | 206,483 | 57.27 | 228.41 |
| sql area evicted | 11 | 0.00 | 0.01 |
| sql area purged | 0 | 0.00 | 0.00 |
| summed dirty queue length | 0 | 0.00 | 0.00 |
| switch current to new buffer | 97 | 0.03 | 0.11 |
| table fetch by rowid | 8,222,917 | 2,280.89 | 9,096.15 |
| table fetch continued row | 504 | 0.14 | 0.56 |
| table scan blocks gotten | 1,064,362 | 295.24 | 1,177.39 |
| table scan rows gotten | 62,500,886 | 17,336.65 | 69,138.15 |
| table scans (direct read) | 0 | 0.00 | 0.00 |
| table scans (long tables) | 0 | 0.00 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 2,924 | 0.81 | 3.23 |
| temp space allocated (bytes) | 0 | 0.00 | 0.00 |
| total cf enq hold time | 120 | 0.03 | 0.13 |
| total number of cf enq holders | 45 | 0.01 | 0.05 |
| total number of times SMON posted | 4 | 0.00 | 0.00 |
| transaction lock background gets | 0 | 0.00 | 0.00 |
| transaction lock foreground requests | 0 | 0.00 | 0.00 |
| transaction lock foreground wait time | 0 | 0.00 | 0.00 |
| transaction rollbacks | 49 | 0.01 | 0.05 |
| transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
| undo change vector size | 1,471,276 | 408.11 | 1,627.52 |
| user I/O wait time | 45 | 0.01 | 0.05 |
| user calls | 36,906 | 10.24 | 40.83 |
| user commits | 899 | 0.25 | 0.99 |
| user rollbacks | 5 | 0.00 | 0.01 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 5,829 | 1.62 | 6.45 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 0 | 0.00 | 0.00 |