SQL Id | SQL Text |
0gj0h89xjnkzb | SELECT /*+ rule */ s.username, decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL, o.owner, o.object_name, o.object_type, s.sid, s.serial#, s.terminal, s.machine, s.program, s.osuser FROM v$session s, v$lock l, dba_objects o WHERE l.sid = s.sid AND l.id1 = o.object_id(+) AND s.username is NOT Null |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0p21nprzuzgv0 | select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id inner join task_report_dim trd on a.task_id = trd.task_id inner join safe_report_info_set sris on trd.report_id = sris.report_code and sris.report_sign='1' and (sris.STATUS is null or sris.STATUS ='1' or sris.STATUS ='3') left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_bank_dim task inner join bank_basis bank on task.bank_id=bank.bank_id where task.bank_id in ( SELECT DISTINCT U.INST_ID FROM NEW_U_BASE_INST_RELA U where (U.INST_ID = :2 OR U.INST_ID_LEVEL_1 = :3 OR U.INST_ID_LEVEL_2 = :4 OR U.INST_ID_LEVEL_3 = :5 OR U.INST_ID_LEVEL_4 = :6 OR U.INST_ID_LEVEL_5 = :7 OR U.INST_ID_LEVEL_6 = :8 ) UNION SELECT DISTINCT RR.RES_DETAIL_VALUE AS INST_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.RES_ID='35' AND RR.SYSTEM_ID=:9 AND RR.OBJECT_ID IN( :10 , :11 ) ) ) and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_report_dim task inner join report_meta report on task.report_id=report.report_id where task.report_id in ( SELECT DISTINCT RR.RES_DETAIL_VALUE AS REPORT_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.SYSTEM_ID=:12 and RR.RES_ID=:13 AND RR.OBJECT_ID IN ( :14 , :15 ) ) ) AND ( tbs.bank_status = :16 ) AND ( a.task_status = :17 ) order by a.report_date desc, b.task_name desc |
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') |
1gu8t96d0bdmu | select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) |
1s21c96ayu4qh | SELECT TRIM(CUSTOMER_NAME) FROM DF_CUSTOMER_PROFILE WHERE TRIM(CUSTOMER_ID) IN ( SELECT TRIM(CUSTOMER_ID) FROM DF_DTP_DAILY_DEALS WHERE TRIM(DEAL_NO)=TRIM(:B2 ) AND ROWNUM=1 ) AND ROWNUM=1 AND SUBSTR(DATA_DATE, 1, 10)=SUBSTR(:B1 , 1, 10) |
2gq55bxkz1h3w | select * from v$access t where t.OBJECT = 'TABLE' |
2q93zsrvbdw48 | select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee# |
350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
3g3k82x8rr54f | insert into DF2_GL_BALANCE_QUERY( Account, Account_Desc, Dept_ID, Dept_ID_Desc, Oper_Unit, Oper_Unit_Desc, Product, Product_Desc, C_Class, C_Class_Desc, Affiliate, Affiliate_Desc, Project_ID, Project_ID_Desc, Tran_Ccy, Tran_Amt, Base_Ccy, Base_Amt, branch, DATA_DATE) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 ) |
3k21pj69wssa8 | INSERT INTO DA_MEND_RISK_RECON_FX (DATA_DATE, PURCCY, PURAMT, SALECCY, SALEAMT, VALUEDATE, CUST_NAME, ACCOUNT_NUMBER, DEALNO, FXCODE, NARRATIONTRAN, CHECK_FLAG, MATCH_TYPE, ORG_ID ) SELECT DATA_DATE, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, JSH_GET_TRADE_RISKRECON(TRIM(SUBSTR(NARRATIONTRAN, 5, LENGTH(NARRATIONTRAN) - 10)), DATA_DATE, 'B'), JSH_GET_TRADE_RISKRECON(TRIM(SUBSTR(NARRATIONTRAN, 5, LENGTH(NARRATIONTRAN) - 10)), DATA_DATE, 'A'), CASE WHEN NARRATIONTRAN LIKE '%DEAL NO.%' THEN SUBSTR(NARRATIONTRAN, INSTR(NARRATIONTRAN, 'DEAL NO.') + 8, 7) ELSE NULL END, FUND_ITEM, NARRATIONTRAN, '0', 'TRADE', BRANCH_ID FROM ( SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM FROM DA_MEND_ACMOV_TRADE WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM FROM DA_MEND_ACMOV_TRDTPI WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM FROM DA_MEND_ACMOV_TRDTPT WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM FROM DA_MEND_ACMOV_TROTP WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL ) WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL AND NARRATIONTRAN NOT IN (SELECT DISTINCT NARRATIONTRAN FROM DA_MEND_RISK_RECON_FX WHERE DATA_DATE = :B1 AND MATCH_TYPE ='TRADE' AND TRIM(NARRATIONTRAN) IS NOT NULL) |
3ktacv9r56b51 | select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# |
3w4qs0tbpmxr6 | select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1 |
3wzwf08xd4w4s | SELECT TRIM(REPLACE(UNIQUEID1, '-', '')) FROM DA_MID_CUST_STATUS WHERE ACCOUNT_NO = :B1 AND UNIQUEID1 IS NOT NULL AND ROWNUM = 1 |
451nas8qa19mp | select bank_id as ID, bank_name as NAME from bank_basis where bank_id in(select member_code from auth_bank_group_member where group_code in (select bank_group_code from auth_user_bank_rights where user_code=:1 and is_user_group in('N', 'n')) union select member_code from auth_bank_group_member where group_code in (select bank_group_code from auth_user_bank_rights where is_user_group in('Y', 'y') and user_code in(select group_code from auth_user_group_member where member_code=:2 ))) order by bank_order |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
4jsqz2txmvamg | SELECT (:B3 +COUNT(1)) FROM UPRR.U_BASE_HOLIDAY HD WHERE HD.HOLIDAY_TYPE = :B2 AND GETDATE(HD.HOLIDAY_VALUE) = :B1 |
53saa2zkr6wc3 | select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1 |
59bd50dx0gnuc | SELECT MASTERNO FROM ( SELECT TRIM(MASTERNO) MASTERNO FROM DA_MID_CUST_STATUS WHERE TRIM(ACCOUNT_NO) = TRIM(:B1 ) AND TRIM(MASTERNO) IS NOT NULL ) T WHERE ROWNUM=1 |
5n1fs4m2n2y0r | select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1 |
61jpjbwnk0540 | SELECT TRIM(CUSTOMER_TYPE) FROM DF_CUSTOMER_PROFILE WHERE TRIM(CUSTOMER_ID) IN ( SELECT TRIM(CUSTOMER_ID) FROM DF_DTP_DAILY_DEALS WHERE TRIM(DEAL_NO)=TRIM(:B2 ) AND ROWNUM=1 ) AND ROWNUM=1 AND SUBSTR(DATA_DATE, 1, 7)=SUBSTR(:B1 , 1, 7) |
6ajkhukk78nsr | begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; |
6aq34nj2zb2n7 | select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# |
70d40ycg6a7wm | select * from v$access t where t.TYPE = 'TABLE' |
7n74kn6jfkrn6 | call etl_da_mend_risk_recon_fx(:1 ) |
7ua2j58f81vrx | SELECT MIN( TRIM( (CASE WHEN CUSTOMER_FULL_NAME_IN_CHINESE IS NULL THEN CUSTOMER_FULL_NAME ELSE CUSTOMER_FULL_NAME_IN_CHINESE END ) ) ) FROM DA_MID_CUST_STATUS WHERE ACCOUNT_NO=:B1 |
83taa7kaw59c1 | select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol# |
87yc7kybat4nz | select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_bank_dim task inner join bank_basis bank on task.bank_id=bank.bank_id where task.bank_id in ( SELECT DISTINCT U.INST_ID FROM NEW_U_BASE_INST_RELA U where (U.INST_ID = :2 OR U.INST_ID_LEVEL_1 = :3 OR U.INST_ID_LEVEL_2 = :4 OR U.INST_ID_LEVEL_3 = :5 OR U.INST_ID_LEVEL_4 = :6 OR U.INST_ID_LEVEL_5 = :7 OR U.INST_ID_LEVEL_6 = :8 ) UNION SELECT DISTINCT RR.RES_DETAIL_VALUE AS INST_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.RES_ID='35' AND RR.SYSTEM_ID=:9 AND RR.OBJECT_ID IN( :10 , :11 , :12 , :13 ) ) ) and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_report_dim task inner join report_meta report on task.report_id=report.report_id where task.report_id in ( SELECT DISTINCT RR.RES_DETAIL_VALUE AS REPORT_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.SYSTEM_ID=:14 and RR.RES_ID=:15 AND RR.OBJECT_ID IN ( :16 , :17 , :18 , :19 ) ) ) AND ( tbs.bank_status = :20 OR tbs.bank_status = :21 OR tbs.bank_status = :22 ) AND ( a.task_status = :23 ) order by a.report_date desc, b.task_name desc |
8s310q37bt7wx | select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_bank_dim task inner join bank_basis bank on task.bank_id=bank.bank_id where task.bank_id in ( SELECT DISTINCT U.INST_ID FROM NEW_U_BASE_INST_RELA U where (U.INST_ID = :2 OR U.INST_ID_LEVEL_1 = :3 OR U.INST_ID_LEVEL_2 = :4 OR U.INST_ID_LEVEL_3 = :5 OR U.INST_ID_LEVEL_4 = :6 OR U.INST_ID_LEVEL_5 = :7 OR U.INST_ID_LEVEL_6 = :8 ) UNION SELECT DISTINCT RR.RES_DETAIL_VALUE AS INST_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.RES_ID='35' AND RR.SYSTEM_ID=:9 AND RR.OBJECT_ID IN( :10 , :11 , :12 , :13 , :14 ) ) ) and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_report_dim task inner join report_meta report on task.report_id=report.report_id where task.report_id in ( SELECT DISTINCT RR.RES_DETAIL_VALUE AS REPORT_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.SYSTEM_ID=:15 and RR.RES_ID=:16 AND RR.OBJECT_ID IN ( :17 , :18 , :19 , :20 , :21 ) ) ) AND ( tbs.bank_status = :22 OR tbs.bank_status = :23 OR tbs.bank_status = :24 ) AND ( a.task_status = :25 ) order by a.report_date desc, b.task_name desc |
8swypbbr0m372 | select order#, columns, types from access$ where d_obj#=:1 |
96g93hntrzjtr | select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 |
9tgj4g8y4rwy8 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
a9u0s3g93f47z | select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj# |
b2gnxm5z6r51n | lock table sys.col_usage$ in exclusive mode nowait |
bdu0m3mj7ctp0 | SELECT 'Y', BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, JSH_GET_TRADE_RISKRECON(TRIM(SUBSTR(NARRATIONTRAN, 5, LENGTH(NARRATIONTRAN) - 10)), DATA_DATE, 'B') , JSH_GET_TRADE_RISKRECON(TRIM(SUBSTR(NARRATIONTRAN, 5, LENGTH(NARRATIONTRAN) - 10)), DATA_DATE, 'A'), CASE WHEN NARRATIONTRAN LIKE '%DEAL NO.%' THEN SUBSTR(NARRATIONTRAN, INSTR(NARRATIONTRAN, 'DEAL NO.') + 8, 7) ELSE '' END, FUND_ITEM, NARRATIONTRAN, BRANCH_ID FROM ( SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM, BRANCH_ID AS ORG_ID FROM DA_MEND_ACMOV_TRADE A WHERE DATA_DATE = :B1 AND A.BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM, BRANCH_ID AS ORG_ID FROM DA_MEND_ACMOV_TRDTPI B WHERE DATA_DATE = :B1 AND B. BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM, BRANCH_ID AS ORG_ID FROM DA_MEND_ACMOV_TRDTPT C WHERE DATA_DATE = :B1 AND C.BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM, BRANCH_ID AS ORG_ID FROM DA_MEND_ACMOV_TROTP D WHERE DATA_DATE = :B1 AND D.BRANCH_ID IS NOT NULL ) WHERE DATA_DATE = :B1 AND ORG_ID IS NOT NULL AND ((BUY_CURR_CD = :B5 AND BUY_AMT = :B4 ) OR (SELL_CURR_CD = :B3 AND SELL_AMT = :B2 )) AND NARRATIONTRAN NOT IN (SELECT DISTINCT NARRATIONTRAN FROM DA_MEND_RISK_RECON_FX WHERE DATA_DATE = :B1 AND MATCH_TYPE='TRADE' AND TRIM(NARRATIONTRAN) IS NOT NULL) AND ROWNUM = 1 |
c21usvaynd7rs | call etl_da_mid_risk_recon_288810(:1 ) |
c3m2v78k06wvy | SELECT NULL AS table_cat, c.owner AS table_schem, c.table_name, c.column_name, c.position AS key_seq, c.constraint_name AS pk_name FROM all_cons_columns c, all_constraints k WHERE k.constraint_type = 'P' AND k.table_name = :1 AND k.owner like :2 escape '/' AND k.constraint_name = c.constraint_name AND k.table_name = c.table_name AND k.owner = c.owner ORDER BY column_name |
cazkts1kztw6h | SELECT PARENT_INST_ID, INST_LAYER FROM UPRR.U_BASE_INST WHERE INST_ID= :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 |
db78fxqxwxt7r | select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket |
fd53yjyv8rk2k | INSERT INTO DA_MID_RISK_RECON_288810 (DATA_DATE, ROW_NO, CCY, AMT, PURCCY, PURAMT, SALECCY, SALEAMT, VALUEDATE, CUST_NAME, ACCOUNT_NUMBER, NARRATION, DEALNO, BR_CODE) SELECT DATA_DATE, TO_CHAR(ROWNUM), TRIM(CCY), NVL(AMOUNT, 0), CASE WHEN TRIM(CR_DR)='D' THEN TRIM(CCY) ELSE NULL END, CASE WHEN TRIM(CR_DR)='D' THEN ABS(NVL(AMOUNT, 0)) ELSE NULL END, CASE WHEN TRIM(CR_DR)='C' THEN TRIM(CCY) ELSE NULL END, CASE WHEN TRIM(CR_DR)='C' THEN ABS(NVL(AMOUNT, 0)) ELSE NULL END, TO_CHAR(TO_DATE(VALUE_DATE), 'yyyy-mm-dd'), JSH_GET_CUSTOMERNAME(TRIM(ACCOUNT_NO), ''), TRIM(ACCOUNT_NO), TRIM(NARRATION), CASE WHEN NARRATION LIKE '%DEAL NO.%' THEN TRIM(SUBSTR(NARRATION, INSTR(NARRATION, 'DEAL NO. ') + 9, 7)) ELSE NULL END, GETCOST_ORGID(REPLACE(LPAD(BR_CODE, 3), ' ', '0'), '01') FROM DF_RISK_RECON_288810 WHERE DATA_DATE =:B1 AND UPPER(TRIM(CCY)) <> 'CNY' AND TRIM(EXTREFNO) IS NOT NULL |
g4qnkaybj4qd5 | SELECT FALG, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, CUSTOMERNAME, ACCOUNT_NUMBER, DEALNO, FUND_ITEM, REFERENCENUMBER, MAKERID, BRANCH_ID FROM (SELECT 'Y' FALG, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, CUSTOMERNAME, CASE WHEN SUBSTR(BUY_ACNUM, 1, 1) ='0' THEN BUY_ACNUM ELSE SELL_ACNUM END ACCOUNT_NUMBER, CASE WHEN NARRATIONTRAN LIKE '%DEAL NO.%' THEN SUBSTR(NARRATIONTRAN, INSTR(NARRATIONTRAN, 'DEAL NO.') + 8, 7) ELSE '' END DEALNO, FUND_ITEM, REFERENCENUMBER, MAKERID, BRANCH_ID FROM DA_MEND_ACMOV_CMS WHERE DATA_DATE = :B5 AND BUY_CURR_CD = :B4 AND BUY_AMT = :B3 AND SELL_CURR_CD = :B2 AND SELL_AMT = :B1 AND (MAKERID, REFERENCENUMBER) NOT IN (SELECT DISTINCT MAKERID, REFERENCENUMBER FROM DA_MEND_RISK_RECON_FX WHERE DATA_DATE = :B5 AND MATCH_TYPE='CMS' AND TRIM(REFERENCENUMBER) IS NOT NULL AND TRIM(MAKERID) IS NOT NULL ) UNION ALL SELECT 'Y' FALG, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, CUSTOMERNAME, CASE WHEN SUBSTR(BUY_ACNUM, 1, 1) ='0' THEN BUY_ACNUM ELSE SELL_ACNUM END ACCOUNT_NUMBER, CASE WHEN NARRATIONTRAN LIKE '%DEAL NO.%' THEN SUBSTR(NARRATIONTRAN, INSTR(NARRATIONTRAN, 'DEAL NO.') + 8, 7) ELSE '' END DEALNO, FUND_ITEM, REFERENCENUMBER, MAKERID, BRANCH_ID FROM DA_MEND_ACMOV_CMS_SH WHERE DATA_DATE = :B5 AND BUY_CURR_CD = :B4 AND BUY_AMT = :B3 AND SELL_CURR_CD = :B2 AND SELL_AMT = :B1 AND (MAKERID, REFERENCENUMBER) NOT IN (SELECT DISTINCT MAKERID, REFERENCENUMBER FROM DA_MEND_RISK_RECON_FX WHERE DATA_DATE = :B5 AND MATCH_TYPE='CMS' AND TRIM(REFERENCENUMBER) IS NOT NULL AND TRIM(MAKERID) IS NOT NULL ) ) A WHERE ROWNUM = 1 |
gb3kwkhf2yrhp | select * from v$access t where t.TYPE = 'TABLE' AND T.OBJECT='DF2_GL_BALANCE_QUERY' |
ghzg8va62bxad | select * from oper_meta where oper_id in (select MEMBER_CODE from AUTH_OPER_GROUP_MEMBER where group_code in (select OPER_GROUP_CODE from AUTH_USER_OPER_RIGHTS where user_code=:1 and is_user_group in('N', 'n')) union select member_code from AUTH_OPER_GROUP_MEMBER where group_code in (select OPER_GROUP_CODE from AUTH_USER_OPER_RIGHTS where is_user_group in('Y', 'y') and user_code in(select group_code from auth_user_group_member where member_code=:2 ))) order by oper_order |
gnmzswnx7jhpb | select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_bank_dim task inner join bank_basis bank on task.bank_id=bank.bank_id where task.bank_id in ( SELECT DISTINCT U.INST_ID FROM NEW_U_BASE_INST_RELA U where (U.INST_ID = :2 OR U.INST_ID_LEVEL_1 = :3 OR U.INST_ID_LEVEL_2 = :4 OR U.INST_ID_LEVEL_3 = :5 OR U.INST_ID_LEVEL_4 = :6 OR U.INST_ID_LEVEL_5 = :7 OR U.INST_ID_LEVEL_6 = :8 ) UNION SELECT DISTINCT RR.RES_DETAIL_VALUE AS INST_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.RES_ID='35' AND RR.SYSTEM_ID=:9 AND RR.OBJECT_ID IN( :10 , :11 ) ) ) and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_report_dim task inner join report_meta report on task.report_id=report.report_id where task.report_id in ( SELECT DISTINCT RR.RES_DETAIL_VALUE AS REPORT_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.SYSTEM_ID=:12 and RR.RES_ID=:13 AND RR.OBJECT_ID IN ( :14 , :15 ) ) ) AND ( tbs.bank_status = :16 OR tbs.bank_status = :17 OR tbs.bank_status = :18 ) AND ( a.task_status = :19 ) order by a.report_date desc, b.task_name desc |
grwydz59pu6mc | select text from view$ where rowid=:1 |
gx4mv66pvj3xz | select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1 |
gzq9b3gr9a6fk | select file#, block# from seg$ where ts# = :1 and hwmincr = :2 |
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 | 4 | 0.00 | 0.00 |
Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
Batched IO double miss count | 1 | 0.00 | 0.00 |
Batched IO same unit count | 1 | 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 | 2 | 0.00 | 0.00 |
Batched IO vector read count | 1 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 4 | 0.00 | 0.00 |
CCursor + sql area evicted | 63 | 0.02 | 0.04 |
CPU used by this session | 398,362 | 110.56 | 268.44 |
CPU used when call started | 397,918 | 110.44 | 268.14 |
CR blocks created | 15 | 0.00 | 0.01 |
Cached Commit SCN referenced | 806 | 0.22 | 0.54 |
Commit SCN cached | 9 | 0.00 | 0.01 |
DB time | 407,050 | 112.97 | 274.29 |
DBWR checkpoint buffers written | 4,043 | 1.12 | 2.72 |
DBWR checkpoints | 2 | 0.00 | 0.00 |
DBWR object drop buffers written | 59 | 0.02 | 0.04 |
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 | 1 | 0.00 | 0.00 |
DBWR transaction table writes | 105 | 0.03 | 0.07 |
DBWR undo block writes | 647 | 0.18 | 0.44 |
HSC Heap Segment Block Changes | 8,217 | 2.28 | 5.54 |
HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 2,088 | 0.58 | 1.41 |
Heap Segment Array Updates | 1,431 | 0.40 | 0.96 |
IMU CR rollbacks | 5 | 0.00 | 0.00 |
IMU Flushes | 458 | 0.13 | 0.31 |
IMU Redo allocation size | 762,724 | 211.69 | 513.96 |
IMU commits | 697 | 0.19 | 0.47 |
IMU contention | 1 | 0.00 | 0.00 |
IMU ktichg flush | 1 | 0.00 | 0.00 |
IMU pool not allocated | 0 | 0.00 | 0.00 |
IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
IMU undo allocation size | 1,783,832 | 495.09 | 1,202.04 |
IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
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 | 4 | 0.00 | 0.00 |
Requests to/from client | 53,567 | 14.87 | 36.10 |
RowCR - row contention | 0 | 0.00 | 0.00 |
RowCR attempts | 7 | 0.00 | 0.00 |
RowCR hits | 10 | 0.00 | 0.01 |
SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 6 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 53,589 | 14.87 | 36.11 |
TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
TBS Extension: files extended | 0 | 0.00 | 0.00 |
TBS Extension: tasks created | 0 | 0.00 | 0.00 |
TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
active txn count during cleanout | 1,053 | 0.29 | 0.71 |
application wait time | 15 | 0.00 | 0.01 |
auto extends on undo tablespace | 0 | 0.00 | 0.00 |
background checkpoints completed | 0 | 0.00 | 0.00 |
background checkpoints started | 0 | 0.00 | 0.00 |
background timeouts | 34,881 | 9.68 | 23.50 |
branch node splits | 0 | 0.00 | 0.00 |
buffer is not pinned count | 2,513,050 | 697.48 | 1,693.43 |
buffer is pinned count | 7,575,896 | 2,102.63 | 5,105.05 |
bytes received via SQL*Net from client | 17,232,655 | 4,782.78 | 11,612.30 |
bytes sent via SQL*Net to client | 21,949,205 | 6,091.82 | 14,790.57 |
calls to get snapshot scn: kcmgss | 132,136 | 36.67 | 89.04 |
calls to kcmgas | 4,486 | 1.25 | 3.02 |
calls to kcmgcs | 671,711 | 186.43 | 452.64 |
cell physical IO interconnect bytes | 2,721,351,236,096 | 755,288,484.10 | 1,833,794,633.49 |
change write time | 42 | 0.01 | 0.03 |
cleanout - number of ktugct calls | 1,070 | 0.30 | 0.72 |
cleanouts and rollbacks - consistent read gets | 1 | 0.00 | 0.00 |
cleanouts only - consistent read gets | 15 | 0.00 | 0.01 |
cluster key scan block gets | 371,031 | 102.98 | 250.02 |
cluster key scans | 359,504 | 99.78 | 242.25 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 333 | 0.09 | 0.22 |
commit batch/immediate requested | 333 | 0.09 | 0.22 |
commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 8 | 0.00 | 0.01 |
commit cleanout failures: cannot pin | 6 | 0.00 | 0.00 |
commit cleanouts | 5,551 | 1.54 | 3.74 |
commit cleanouts successfully completed | 5,537 | 1.54 | 3.73 |
commit immediate performed | 333 | 0.09 | 0.22 |
commit immediate requested | 333 | 0.09 | 0.22 |
commit txn count during cleanout | 79 | 0.02 | 0.05 |
concurrency wait time | 358,962 | 99.63 | 241.89 |
consistent changes | 80 | 0.02 | 0.05 |
consistent gets | 36,476,831 | 10,123.84 | 24,580.07 |
consistent gets - examination | 2,309,307 | 640.93 | 1,556.14 |
consistent gets direct | 15 | 0.00 | 0.01 |
consistent gets from cache | 36,476,816 | 10,123.84 | 24,580.06 |
consistent gets from cache (fastpath) | 34,135,270 | 9,473.96 | 23,002.20 |
cursor authentications | 1,118 | 0.31 | 0.75 |
data blocks consistent reads - undo records applied | 14 | 0.00 | 0.01 |
db block changes | 38,751 | 10.76 | 26.11 |
db block gets | 46,474 | 12.90 | 31.32 |
db block gets direct | 49 | 0.01 | 0.03 |
db block gets from cache | 46,425 | 12.88 | 31.28 |
db block gets from cache (fastpath) | 9,535 | 2.65 | 6.43 |
deferred (CURRENT) block cleanout applications | 2,514 | 0.70 | 1.69 |
dirty buffers inspected | 11 | 0.00 | 0.01 |
doubling up with imu segment | 0 | 0.00 | 0.00 |
drop segment calls in space pressure | 0 | 0.00 | 0.00 |
enqueue conversions | 1,890 | 0.52 | 1.27 |
enqueue deadlocks | 0 | 0.00 | 0.00 |
enqueue releases | 13,320 | 3.70 | 8.98 |
enqueue requests | 13,339 | 3.70 | 8.99 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 7 | 0.00 | 0.00 |
exchange deadlocks | 0 | 0.00 | 0.00 |
execute count | 121,651 | 33.76 | 81.98 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 33,089,347 | 9,183.67 | 22,297.40 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 150,683 | 41.82 | 101.54 |
free buffer requested | 153,741 | 42.67 | 103.60 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
global undo segment hints were stale | 0 | 0.00 | 0.00 |
heap block compress | 93 | 0.03 | 0.06 |
hot buffers moved to head of LRU | 8,569 | 2.38 | 5.77 |
immediate (CR) block cleanout applications | 16 | 0.00 | 0.01 |
immediate (CURRENT) block cleanout applications | 326 | 0.09 | 0.22 |
in call idle wait time | 13,335,339 | 3,701.11 | 8,986.08 |
index crx upgrade (positioned) | 27 | 0.01 | 0.02 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 884 | 0.25 | 0.60 |
index fetch by key | 4,830,043 | 1,340.54 | 3,254.75 |
index scans kdiixs1 | 571,202 | 158.53 | 384.91 |
leaf node 90-10 splits | 37 | 0.01 | 0.02 |
leaf node splits | 55 | 0.02 | 0.04 |
lob reads | 295 | 0.08 | 0.20 |
lob writes | 171 | 0.05 | 0.12 |
lob writes unaligned | 171 | 0.05 | 0.12 |
local undo segment hints helped | 0 | 0.00 | 0.00 |
logical read bytes from cache | 299,198,390,272 | 83,040,033.80 | 201,616,165.95 |
logons cumulative | 66 | 0.02 | 0.04 |
max cf enq hold time | 90 | 0.02 | 0.06 |
messages received | 12,814 | 3.56 | 8.63 |
messages sent | 12,814 | 3.56 | 8.63 |
min active SCN optimization applied on CR | 0 | 0.00 | 0.00 |
no buffer to keep pinned count | 404 | 0.11 | 0.27 |
no work - consistent read gets | 33,470,851 | 9,289.56 | 22,554.48 |
non-idle wait count | 3,439,718 | 954.67 | 2,317.87 |
non-idle wait time | 509,837 | 141.50 | 343.56 |
opened cursors cumulative | 116,024 | 32.20 | 78.18 |
parse count (describe) | 7 | 0.00 | 0.00 |
parse count (failures) | 4 | 0.00 | 0.00 |
parse count (hard) | 2,421 | 0.67 | 1.63 |
parse count (total) | 9,506 | 2.64 | 6.41 |
parse time cpu | 1,598 | 0.44 | 1.08 |
parse time elapsed | 1,716 | 0.48 | 1.16 |
physical read IO requests | 6,310 | 1.75 | 4.25 |
physical read bytes | 1,234,354,176 | 342,584.77 | 831,775.05 |
physical read total IO requests | 3,315,564 | 920.21 | 2,234.21 |
physical read total bytes | 2,721,219,817,984 | 755,252,010.09 | 1,833,706,076.81 |
physical read total multi block requests | 2,584,768 | 717.38 | 1,741.76 |
physical reads | 150,678 | 41.82 | 101.54 |
physical reads cache | 150,663 | 41.82 | 101.52 |
physical reads cache prefetch | 144,384 | 40.07 | 97.29 |
physical reads direct | 15 | 0.00 | 0.01 |
physical reads direct (lob) | 4 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 1,697 | 0.47 | 1.14 |
physical write bytes | 34,586,624 | 9,599.23 | 23,306.35 |
physical write total IO requests | 10,019 | 2.78 | 6.75 |
physical write total bytes | 131,418,112 | 36,474.01 | 88,556.68 |
physical write total multi block requests | 150 | 0.04 | 0.10 |
physical writes | 4,222 | 1.17 | 2.85 |
physical writes direct | 49 | 0.01 | 0.03 |
physical writes direct (lob) | 20 | 0.01 | 0.01 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 4,173 | 1.16 | 2.81 |
physical writes non checkpoint | 2,570 | 0.71 | 1.73 |
pinned buffers inspected | 0 | 0.00 | 0.00 |
pinned cursors current | 3 | 0.00 | 0.00 |
prefetch clients - default | 62 | 0.02 | 0.04 |
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 | 3,553 | 0.99 | 2.39 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 212,154 | 58.88 | 142.96 |
recursive cpu usage | 369,981 | 102.69 | 249.31 |
redo KB read | 2,645,512,747 | 734,240.14 | 1,782,690.53 |
redo KB read (memory) | 1,098,273 | 304.82 | 740.08 |
redo blocks checksummed by FG (exclusive) | 18,869 | 5.24 | 12.71 |
redo blocks checksummed by LGWR | 1,009 | 0.28 | 0.68 |
redo blocks written | 31,394 | 8.71 | 21.15 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 23,806 | 6.61 | 16.04 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 635 | 0.18 | 0.43 |
redo size | 15,044,368 | 4,175.44 | 10,137.71 |
redo size for direct writes | 403,172 | 111.90 | 271.68 |
redo subscn max counts | 2,620 | 0.73 | 1.77 |
redo synch long waits | 11 | 0.00 | 0.01 |
redo synch time | 234 | 0.06 | 0.16 |
redo synch time (usec) | 2,375,377 | 659.27 | 1,600.66 |
redo synch writes | 1,566 | 0.43 | 1.06 |
redo wastage | 518,988 | 144.04 | 349.72 |
redo write time | 520 | 0.14 | 0.35 |
redo writes | 2,181 | 0.61 | 1.47 |
rollback changes - undo records applied | 338 | 0.09 | 0.23 |
rollbacks only - consistent read gets | 13 | 0.00 | 0.01 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 572,630 | 158.93 | 385.87 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 41,956 | 11.64 | 28.27 |
session logical reads | 36,523,305 | 10,136.74 | 24,611.39 |
shared hash latch upgrades - no wait | 25,328 | 7.03 | 17.07 |
shared hash latch upgrades - wait | 73 | 0.02 | 0.05 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 547,266 | 151.89 | 368.78 |
sorts (rows) | 4,417,876 | 1,226.14 | 2,977.01 |
space was found by tune down | 0 | 0.00 | 0.00 |
sql area evicted | 2,269 | 0.63 | 1.53 |
sql area purged | 5 | 0.00 | 0.00 |
steps of tune down ret. in space pressure | 0 | 0.00 | 0.00 |
summed dirty queue length | 13 | 0.00 | 0.01 |
switch current to new buffer | 1,614 | 0.45 | 1.09 |
table fetch by rowid | 3,960,804 | 1,099.29 | 2,669.01 |
table fetch continued row | 312 | 0.09 | 0.21 |
table scan blocks gotten | 31,530,721 | 8,751.09 | 21,247.12 |
table scan rows gotten | 1,085,161,459 | 301,177.57 | 731,240.88 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 313 | 0.09 | 0.21 |
table scans (short tables) | 588,655 | 163.38 | 396.67 |
temp space allocated (bytes) | 1,048,576 | 291.02 | 706.59 |
total cf enq hold time | 6,560 | 1.82 | 4.42 |
total number of cf enq holders | 708 | 0.20 | 0.48 |
total number of times SMON posted | 339 | 0.09 | 0.23 |
transaction rollbacks | 332 | 0.09 | 0.22 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
tune down retentions in space pressure | 0 | 0.00 | 0.00 |
undo change vector size | 2,214,196 | 614.53 | 1,492.05 |
user I/O wait time | 15,993 | 4.44 | 10.78 |
user calls | 76,064 | 21.11 | 51.26 |
user commits | 824 | 0.23 | 0.56 |
user rollbacks | 660 | 0.18 | 0.44 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 540,543 | 150.02 | 364.25 |
write clones created in background | 58 | 0.02 | 0.04 |
write clones created in foreground | 0 | 0.00 | 0.00 |