| SQL Id | SQL Text |
|---|
| 04qrcm4qcz690 | select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6, :7) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 |
| 09v2x5y18u9uu | select f.file_body from sys_file f, sys_file2 f2 where f.flow_inid=f2.flow_inid and f.file_name=f2.file_name and f2.flow_inid=:1 and f2.file_name=:2 |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0sck1avakd8up | select 1 from sys_file2 where file_name=:1 and (flow_inid=:2 or ref_inid=:3) |
| 0ufr9a9z4vj0x | Select A.modu_id, A.func_id, A.IsIncluded, A.IsVisible, A.HasFrame, A.AllowRemove, A.AllowMinimize, A.Zone, A.FrameState, A.HeightEnabled, A.Height, A.HeightUnitType, A.WidthEnabled, A.Width, A.WidthUnitType, A.RequiresIsolation, A.RefreshInterval, A.DashboardOrder, 0 as modu_type, 0 as func_type, B.Title AS Title, B.Description AS Description, B.href as href, B.href_desc as href_desc FROM modu_func A, func_def B Where A.func_id = B.func_id and A.modu_id = '00390001' AND (B.func_id in( select func_id from Func_Right r where (user_code = 'zgningk' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ((select grop_code from user_group where user_code='zgningk'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='zgningk' and b.fram_code like a.fram_code || '%')) group by func_id having max( allow_use) = 1 and max(deny_use) = 0 )) ORDER BY A.zone asc, A.DashBoardOrder asc |
| 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') |
| 0y5hsh9q9ppra | select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1))) order by crt_date desc, record_code asc, record_pri asc) where rownum<=:10 |
| 169m46hd90w10 | SELECT U_NAME FROM USERS WHERE U_NAME = :1 |
| 16hmhrs8q5zxc | select C_FLOW_INID, C_FLOW_INID from YW_HS_PAY |
| 19x1189chq3xd | SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE |
| 1bkx3ssq6ra7s | select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7) and r.deny_right=1))) order by record_pri asc, crt_date desc |
| 1g4zgsm9xpd4m | select SIGN_PROJECTNAME, SIGN_PROJECTNAME from YW_ZT_CONTRACT_APPR |
| 1rfb4y9054rxc | SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6, :7) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1 |
| 1zt0h65qy3ax0 | select PACT_NAME, PACT_NAME from YW_ZT_PAY |
| 20fdfnf0rad6f | select item_seq from tree_def where item_type=2 and ( crt_user=:1 or ( exists( select 1 from right_def where right_def.item_seq=tree_def.item_seq and right_def.user_name IN (:2, :3, :4, :5, :6, :7, :8) having (min(op_acc) = 0 )))) |
| 20zsqv8cyns4q | UPDATE DEAL_INFO SET STEP_CHOI = :1 , CHOI_CONT = :2 , READ_FLAG = :3 , SAVE_DATE = :4 , DEAL_COMM = :5 WHERE DEAL_INDX = :6 AND FLOW_INID = :7 AND STEP_INCO = :8 |
| 23nad9x295gkf | SELECT (m.current_size / 1048576) as sizemb, case when cast(m.last_oper_time as timestamp) > s.end_interval_time then 1 else 0 end as changed, decode( m.component , 'shared pool', 1, 'streams pool', 2, 'DEFAULT buffer cache', 3, 'DEFAULT 2K buffer cache', 4, 'DEFAULT 4K buffer cache', 5, 'DEFAULT 8K buffer cache', 6, 'DEFAULT 16K buffer cache', 7, 'DEFAULT 32K buffer cache', 8, 'SGA Target', 9, 'PGA Target', 10, 'memory target', 11 , 255) as comp_id FROM WRH$_MEM_DYNAMIC_COMP m , WRM$_SNAPSHOT s WHERE m.dbid = :dbid AND m.instance_number = :inst_num AND m.snap_id = :end_snap_id AND s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id = :begin_snap_id |
| 276pg3b9jj6s2 | SELECT U_PASSWORD FROM USERS WHERE U_NAME = :1 |
| 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 |
| 3ck5nawakfufd | select count(record_code) from pu_record where (record_status=1 and ( folder_code =:1)) and (( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8) and r.deny_right=1)))) |
| 43u6hc60tjs39 | select f.file_name, f.ref_inid, f.if_arj from sys_file2 f, flow_inst t where f.flow_inid=t.flow_inid and f.file_name<>t.doc_name and f.flow_inid=:1 order by f.FILE_INID |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 4zhbk56w939x2 | update DEAL_INFO set DEAL_COMM=empty_clob() WHERE DEAL_INDX = :1 AND FLOW_INID = :2 AND STEP_INCO = :3 |
| 53wunym0kqf78 | select fram_seq from framework where fram_code in (:1, :2, :3, :4) |
| 5856axycgda5p | select * from (select rownum as rowindex, temp.* from (select * from pu_record where (record_status=1 and ( folder_code =:1)) and (( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1)))) order by record_pri asc, crt_date desc) temp where rownum <=:10 ) where rowindex>= :11 |
| 5d8actn77qfu3 | insert into LOG_RECORD(LOG_ID, LOG_TYPE, USER_CODE, MODU_ID, MODU_CODE, MODU_NAME, REMOTE_IP, LOG_LEVL, OPER_DESC, OPER_NAME, OPER_RESU, OPER_ARRA, RECD_TIME, SYS_ID, ATTACH_F1, ATTACH_F2, ATTACH_F3, ATTACH_F4, ATTACH_F5) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19) |
| 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 |
| 5k2b3qsy3b30r | /* OracleOEM */ WITH blocked_resources AS (select id1 , id2 , SUM(ctime) as blocked_secs , MAX(request) as max_request , COUNT(1) as blocked_count from v$lock where request > 0 group by id1, id2 ) , blockers AS (select L.* , BR.blocked_secs , BR.blocked_count from v$lock L , blocked_resources BR where BR.id1 = L.id1 and BR.id2 = L.id2 and L.lmode > 0 and L.block <> 0 ) select B.id1||'_'||B.id2||'_'||S.sid||'_'||S.serial# as id , 'SID, SERIAL:'||S.sid||', '||S.serial#||', LOCK_TYPE:'||B.type||', PROGRAM:'||S.program||', MODULE:'||S.module||', ACTION:'||S.action||', MACHINE:'||S.machine||', OSUSER:'||S.osuser||', USERNAME:'||S.username as info , B.blocked_secs , B.blocked_count from v$session S , blockers B where B.sid = S.sid |
| 5nhtksz627ru6 | select item_seq from tree_def where item_type=2 and ( crt_user=:1 or ( exists( select 1 from right_def where right_def.item_seq=tree_def.item_seq and right_def.user_name IN (:2, :3, :4, :5, :6, :7, :8, :9) having (min(op_acc) = 0 )))) |
| 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 |
| 62jd0x1sdk42m | /* OracleOEM */ DECLARE rept varchar2(4000); rref varchar2(4000); key_enable varchar2(20); autoimpl_enable varchar2(20); key_count number; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; BEGIN rref := dbms_report.build_report_reference_varg( 'sqltune', 'auto_summary', 'section', 'task_stats', 'validate', 'n'); rept := dbms_report.get_report(rref); WITH data AS (select xmltype(rept) rept_xml FROM dual) SELECT extractvalue(rept_xml, '/report/summary/statistics/task_stats/info_group/info[position()=1]'), extractvalue(rept_xml, '/report/summary/statistics/task_stats/info_group/info[position()=2]') INTO key_enable, autoimpl_enable FROM data; SELECT count(*) INTO key_count FROM table(xmlsequence(xmltype(rept).extract('//obj_id'))); OPEN data_cursor FOR SELECT key_count, key_enable, autoimpl_enable FROM dual; :1 := data_cursor; END; |
| 6374kbmr15cdp | UPDATE DEAL_INFO SET DEAL_COMM = :1 WHERE DEAL_INDX = :2 AND FLOW_INID = :3 AND STEP_INCO = :4 |
| 6501mstynpg0v | SELECT FRAMNAME2 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1 |
| 69k5bhm12sz98 | SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst |
| 6x7vjkqcpzwtx | select * from flow_inst where flow_inid=:1 |
| 6xj082k5dca3t | select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 |
| 7gzxf61vj6wq4 | SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1 |
| 7q4r141ap4ctu | select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11, :12) and r.deny_right=1))) order by record_pri asc, crt_date desc |
| 8nt4d5vvrzxuc | select FULL_NAME, USER_CODE from V_FORM_HSXMZ |
| 8ugs0u05kzhdc | select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 and crt_date > TO_DATE(:2, 'YYYY-MM-DD')) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:3 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:4 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:5, :6, :7, :8, :9, :10) and r.deny_right=1))) order by crt_date desc, record_code asc, record_pri asc |
| 8vx0yn7u2n6xn | select FRAMNAME, USER_CODE from V_YW_USER_AREANAME |
| 9hssygbh57pq2 | SELECT a.user_code, a.modu_id, a.func_id, a.modu_type, a.func_type, a.IsIncluded, a.IsVisible, a.HasFrame, a.AllowRemove, a.AllowMinimize, a.Zone, a.FrameState, a.HeightEnabled, a.Height, a.HeightUnitType, a.WidthEnabled, a.Width, a.WidthUnitType, a.RequiresIsolation, a.DashboardOrder, A.RefreshInterval AS RefreshInterval, B.Title AS Title, B.Description AS Description, B.href as href, B.href_desc as href_desc FROM user_prof A, pers_func B where A.func_id = B.func_id and A.modu_id='003900020015' and A.func_type = 1 and A.user_code= B.user_code and A.user_code ='wugh' and A.MODU_TYPE=0 UNION SELECT c.user_code, c.modu_id, c.func_id, c.modu_type, c.func_type, c.IsIncluded, c.IsVisible, c.HasFrame, c.AllowRemove, c.AllowMinimize, c.Zone, c.FrameState, c.HeightEnabled, c.Height, c.HeightUnitType, c.WidthEnabled, c.Width, c.WidthUnitType, c.RequiresIsolation, c.DashboardOrder, C.RefreshInterval AS RefreshInterval, D.Title AS Title, D.Description AS Description, D.href as href, D.href_desc as href_desc FROM user_prof C, func_def D where C.func_id = D.func_id and C.func_type = 0 and C.user_code ='wugh' and C.MODU_TYPE=0 and C.modu_id='003900020015' AND (D.func_id in( select func_id from Func_Right r where (user_code = 'wugh' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ((select grop_code from user_group where user_code='wugh'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='wugh' and b.fram_code like a.fram_code || '%')) group by func_id having max( allow_use) = 1 and max(deny_use) = 0 )) |
| 9w2qykn1r44zd | select count(*) as CNT from deal_info d left join step_inst si on d.step_inco=si.step_inco left join step_def sd on si.step_code=sd.step_code where si.send_flag=0 and d.flow_inid=:1 and (sd.step_tag=:2 or sd.step_name=:3) |
| 9xcfqrw82z34g | select SIGN_PROJECTNAME, SIGN_PROJECTNAME from YW_ZT_PAY |
| a2h7ax6s9hab9 | select DEAL_COMM from DEAL_INFO WHERE DEAL_INDX = :1 AND FLOW_INID = :2 AND STEP_INCO = :3 for update |
| a94uh0q35gtby | select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10) and r.deny_right=1))) order by record_pri asc, crt_date desc |
| afxn34s636ba8 | select C_FLOW_INID, C_FLOW_INID from YW_ZT_CONTRACT_APPR |
| ahxtwjz5p0g30 | SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1 |
| awbdm98u8fvn0 | SELECT FLOW_INID, STEP_INCO, DEAL_INDX, PERI_MAN, STEP_MAN, DEAL_MAN, FULL_NAME, AGEN_MEN, DEAL_EFFE, STEP_CHOI, CHOI_CONT, NEXT_EFFE, NEXT_MAN, CURR_MAN, STEP_TYPE, RECE_DATE, FINI_DATE, FINI_FLAG, READ_FLAG, SAVE_DATE, DEAL_SIGN, DEL_FLAG, NOTE_MAN, URGE_INFO, DEAL_NOTE, URGE_DATE, REMIND_TYPE, TIME_SET, URGE_TIMES, URGE_SET, URGE_FINI_FLAG, REGI_FLAG, FSUB_INID, FW_MAN, FSUB_FLAG, STEP_INDEX, BACK_FLAG, OPEN_DATE, SELF_SCORE, OTHER_SCORE, OPEN_TERM, DEAL_TERM, PRE_DEAL_IDX, SUB_DEAL_CNT, APPEND_PATH, HAS_SYNC, ALLOGRAPH, ARCH_FLAG, CA_SIGN_STATE, FORM_SIGN_VERIFY_DATA, ALLOGRAPH_DATE, DEAL_COMM, AGEN_FLAG, FLOW_ID, STEP_CODE, DREDGE_REASON, DREDGE_MAN, DREDGE_DATE, URGE_COUNT FROM DEAL_INFO WHERE DEAL_INDX = :1 AND FLOW_INID = :2 AND STEP_INCO = :3 |
| b6y5hkzmgx601 | select modu_def.modu_id, modu_def.para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, AllowPersonize, user_modu.modu_type, user_modu.isshowtree, user_modu.sort_id as DashBoardOrder from user_modu, modu_def where user_modu.modu_type = 0 and user_code = 'libohong' and user_modu.modu_id = modu_def.modu_id and ( para_id is null or para_id like '0039%' ) and ALLOWUSE=1 and (modu_def.modu_id in ( select modu_id from Modu_Right r where (user_code = 'libohong' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ( (select grop_code from user_group where user_code='libohong'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='libohong' and b.fram_code like a.fram_code || '%')) group by modu_id having max( allow_use) = 1 and max(deny_use) = 0 )) UNION SELECT modu_id, para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, AllowPersonize, 0 AS modu_type, 1 as isshowtree, DashBoardOrder FROM MODU_DEF WHERE MODU_ID NOT IN(SELECT MODU_ID FROM USER_MODU WHERE MODU_TYPE=0 AND USER_CODE='libohong') AND ALLOWUSE=1 and (modu_def.modu_id in ( select modu_id from Modu_Right r where (user_code = 'libohong' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ( (select grop_code from user_group where user_code='libohong'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='libohong' and b.fram_code like a.fram_code || '%')) group by modu_id having max( allow_use) = 1 and max(deny_use) = 0 )) UNION select pers_modu.modu_id, pers_modu.para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, 1 as AllowPersonize, user_modu.modu_type, user_modu.isshowtree, user_modu.sort_id as DashBoardOrder from user_modu, pers_modu where user_modu.modu_type = 1 and user_modu.user_code = 'libohong' and pers_modu.user_code = 'libohong' and user_modu.modu_id = pers_modu.modu_id and (para_id is null ) AND USE_FLAG=1 UNION SELECT modu_id, para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, 1 AS AllowPersonize, 1 AS modu_type, 1 as isshowtree, DashBoardOrder FROM PERS_MODU WHERE MODU_ID NOT IN(SELECT MODU_ID FROM USER_MODU WHERE MODU_TYPE=1 AND USER_CODE='libohong') AND USER_CODE='libohong' order by para_id, DashBoardOrder |
| b8k52qq2a8z9d | select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8) and r.deny_right=1))) order by record_pri asc, crt_date desc |
| bdra985w3wh0b | select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1))) order by record_pri asc, crt_date desc |
| bjn4vnyg20p7s | select count(record_code) from pu_record where (record_status=1 and ( folder_code =:1)) and (( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1)))) |
| c3hhngpbpvvmk | SELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :B1 |
| 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 |
| c4d6d9kwzwkqt | select user_sign from usersign where user_code=:1 |
| c4f1v62z1pfgz | SELECT FRAMNAME3 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1 |
| cb7zvbajzhbq7 | select dept_code from framedepartment where fram_code in (select max(f.fram_code) from pt_style_config a, user_dept d, framedepartment f, framedepartment fd where a.sys_id=:1 and a.user_code=f.dept_code and d.user_code=:2 and d.fram_seq = fd.dept_code and fd.fram_code like f.fram_code||'%') |
| cdmuy04h09jr8 | select FULL_NAME, USER_CODE from V_FORM_ZJDQRL |
| chr72bqg3x425 | SELECT FRAMNAME5 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1 |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cujtvqu9tn50f | SELECT /*+ leading(oe f r l) */ /* STN_REPT_TOP_PROF */ xmlelement( "top_profiles", xmlagg(xmlelement("obj_id", object_id))) FROM (SELECT task_id, exec_name, exec_id, exec_start, object_id, sql_id, parsing_schema, phv, obj_attr8 FROM (SELECT /*+ cardinality(o 6823) leading(e o) */ e.task_id task_id, e.execution_name exec_name, e.execution_id exec_id, e.execution_start exec_start, o.id object_id, o.attr1 sql_id, o.attr3 parsing_schema, to_number(nvl(o.attr5, '0')) phv, nvl(o.attr8, 0) obj_attr8, row_number() over (partition by o.attr1 order by bitand(o.attr7, 32) asc, e.execution_start desc) rn FROM (SELECT e.task_id, e.name execution_name, e.id execution_id, e.exec_start execution_start, e.status status# FROM (SELECT task_id, min(execution_name) keep (dense_rank first order by execution_start) bename, max(execution_name) keep (dense_rank last order by execution_start) eename, min(execution_start) bestart, max(execution_start) eestart FROM (SELECT task_id, name execution_name, exec_start execution_start FROM wri$_adv_executions WHERE task_id = :tid and name in (:bename, :eename)) GROUP BY task_id) r, wri$_adv_executions e WHERE e.task_id = r.task_id and e.exec_start >= bestart and e.exec_start <= eestart and e.status IN (3, 4) and (bename <> eename OR e.name = bename)) e /* e */, wri$_adv_objects o WHERE o.task_id = e.task_id AND o.exec_name = e.execution_name AND o.type = :sqltyp) WHERE rn = 1) oe /* oe */, wri$_adv_findings f, wri$_adv_recommendations r, wri$_adv_rationale l WHERE oe.task_id = f.task_id AND oe.exec_name = f.exec_name AND oe.object_id = f.obj_id AND f.task_id = r.task_id AND f.exec_name = r.exec_name AND f.id = r.finding_id AND l.task_id = r.task_id AND l.exec_name = r.exec_name AND l.rec_id = r.id AND r.type = :profiletyp AND l.type = :impltyp AND l.attr1 = :acceptdis AND NOT EXISTS (SELECT 1 FROM dba_sql_profiles p WHERE p.task_id = r.task_id AND p.task_exec_name = r.exec_name AND p.task_obj_id = oe.object_id AND p.task_fnd_id = r.finding_id AND p.task_rec_id = r.id) |
| cyrdykg80yur1 | UPDATE STEP_INST SET SAVE_DATE = :1 WHERE FLOW_INID = :2 AND STEP_INCO = :3 |
| d1ra7j6na0h1a | INSERT INTO DEAL_INFO (FLOW_INID, STEP_INCO, DEAL_INDX, PERI_MAN, STEP_MAN, DEAL_MAN, FULL_NAME, AGEN_MEN, DEAL_EFFE, STEP_CHOI, CHOI_CONT, NEXT_EFFE, NEXT_MAN, CURR_MAN, STEP_TYPE, RECE_DATE, FINI_DATE, FINI_FLAG, READ_FLAG, SAVE_DATE, DEAL_SIGN, DEL_FLAG, NOTE_MAN, URGE_INFO, DEAL_NOTE, URGE_DATE, REMIND_TYPE, TIME_SET, URGE_TIMES, URGE_SET, URGE_FINI_FLAG, REGI_FLAG, FSUB_INID, FW_MAN, FSUB_FLAG, STEP_INDEX, BACK_FLAG, OPEN_DATE, SELF_SCORE, OTHER_SCORE, OPEN_TERM, DEAL_TERM, PRE_DEAL_IDX, SUB_DEAL_CNT, APPEND_PATH, HAS_SYNC, ALLOGRAPH, ARCH_FLAG, CA_SIGN_STATE, FORM_SIGN_VERIFY_DATA, ALLOGRAPH_DATE, DEAL_COMM, AGEN_FLAG, FLOW_ID, STEP_CODE, DREDGE_REASON, DREDGE_MAN, DREDGE_DATE, URGE_COUNT) VALUES (:1, :2, :3, :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, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59) |
| da7mkv3ngfq7a | select FRAMNAME, USER_CODE from V_CENTER_LEADERASDIFO_ZJ |
| dftfchx9vpuya | SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(db_user) AS failed_count FROM sys.dba_common_audit_trail WHERE action BETWEEN 100 AND 102 AND returncode != 0 AND TO_CHAR(extended_timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS') |
| dv5by8ftrrt41 | UPDATE STEP_INST SET STEP_STAT = :1 , SAVE_FLAG = :2 , SAVE_DATE = :3 WHERE FLOW_INID = :4 AND STEP_INCO = :5 |
| f5t247xd2z7gh | select count(*) as CNT from flow_inst A left join step_inst B on A.curr_step=B.step_inco where (A.del_flag is null or A.del_flag=0) and A.if_efec<>2 and A.fins_name like :1 |
| frayzgcu4bs4x | SELECT a.user_code, a.modu_id, a.func_id, a.modu_type, a.func_type, a.IsIncluded, a.IsVisible, a.HasFrame, a.AllowRemove, a.AllowMinimize, a.Zone, a.FrameState, a.HeightEnabled, a.Height, a.HeightUnitType, a.WidthEnabled, a.Width, a.WidthUnitType, a.RequiresIsolation, a.DashboardOrder, A.RefreshInterval AS RefreshInterval, B.Title AS Title, B.Description AS Description, B.href as href, B.href_desc as href_desc FROM user_prof A, pers_func B where A.func_id = B.func_id and A.modu_id='00390001' and A.func_type = 1 and A.user_code= B.user_code and A.user_code ='zgningk' and A.MODU_TYPE=0 UNION SELECT c.user_code, c.modu_id, c.func_id, c.modu_type, c.func_type, c.IsIncluded, c.IsVisible, c.HasFrame, c.AllowRemove, c.AllowMinimize, c.Zone, c.FrameState, c.HeightEnabled, c.Height, c.HeightUnitType, c.WidthEnabled, c.Width, c.WidthUnitType, c.RequiresIsolation, c.DashboardOrder, C.RefreshInterval AS RefreshInterval, D.Title AS Title, D.Description AS Description, D.href as href, D.href_desc as href_desc FROM user_prof C, func_def D where C.func_id = D.func_id and C.func_type = 0 and C.user_code ='zgningk' and C.MODU_TYPE=0 and C.modu_id='00390001' AND (D.func_id in( select func_id from Func_Right r where (user_code = 'zgningk' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ((select grop_code from user_group where user_code='zgningk'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='zgningk' and b.fram_code like a.fram_code || '%')) group by func_id having max( allow_use) = 1 and max(deny_use) = 0 )) |
| frrxps2qhj61s | select modu_def.modu_id, modu_def.para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, AllowPersonize, user_modu.modu_type, user_modu.isshowtree, user_modu.sort_id as DashBoardOrder from user_modu, modu_def where user_modu.modu_type = 0 and user_code = 'heyang' and user_modu.modu_id = modu_def.modu_id and ( para_id is null or para_id like '0039%' ) and ALLOWUSE=1 and (modu_def.modu_id in ( select modu_id from Modu_Right r where (user_code = 'heyang' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ( (select grop_code from user_group where user_code='heyang'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='heyang' and b.fram_code like a.fram_code || '%')) group by modu_id having max( allow_use) = 1 and max(deny_use) = 0 )) UNION SELECT modu_id, para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, AllowPersonize, 0 AS modu_type, 1 as isshowtree, DashBoardOrder FROM MODU_DEF WHERE MODU_ID NOT IN(SELECT MODU_ID FROM USER_MODU WHERE MODU_TYPE=0 AND USER_CODE='heyang') AND ALLOWUSE=1 and (modu_def.modu_id in ( select modu_id from Modu_Right r where (user_code = 'heyang' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ( (select grop_code from user_group where user_code='heyang'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='heyang' and b.fram_code like a.fram_code || '%')) group by modu_id having max( allow_use) = 1 and max(deny_use) = 0 )) UNION select pers_modu.modu_id, pers_modu.para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, 1 as AllowPersonize, user_modu.modu_type, user_modu.isshowtree, user_modu.sort_id as DashBoardOrder from user_modu, pers_modu where user_modu.modu_type = 1 and user_modu.user_code = 'heyang' and pers_modu.user_code = 'heyang' and user_modu.modu_id = pers_modu.modu_id and (para_id is null ) AND USE_FLAG=1 UNION SELECT modu_id, para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, 1 AS AllowPersonize, 1 AS modu_type, 1 as isshowtree, DashBoardOrder FROM PERS_MODU WHERE MODU_ID NOT IN(SELECT MODU_ID FROM USER_MODU WHERE MODU_TYPE=1 AND USER_CODE='heyang') AND USER_CODE='heyang' order by para_id, DashBoardOrder |
| fuv260cu4xtpp | SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC, flow_inst AA where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and AA.fins_name like :1 and CC.deal_man in (:2, :3, :4, :5, :6, :7, :8) and AA.flow_inid=CC.flow_inid group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1 |
| gb1f045s0v0q8 | select modu_def.modu_id, modu_def.para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, AllowPersonize, user_modu.modu_type, user_modu.isshowtree, user_modu.sort_id as DashBoardOrder from user_modu, modu_def where user_modu.modu_type = 0 and user_code = 'cailf' and user_modu.modu_id = modu_def.modu_id and ( para_id is null or para_id like '0039%' ) and ALLOWUSE=1 and (modu_def.modu_id in ( select modu_id from Modu_Right r where (user_code = 'cailf' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ( (select grop_code from user_group where user_code='cailf'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='cailf' and b.fram_code like a.fram_code || '%')) group by modu_id having max( allow_use) = 1 and max(deny_use) = 0 )) UNION SELECT modu_id, para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, AllowPersonize, 0 AS modu_type, 1 as isshowtree, DashBoardOrder FROM MODU_DEF WHERE MODU_ID NOT IN(SELECT MODU_ID FROM USER_MODU WHERE MODU_TYPE=0 AND USER_CODE='cailf') AND ALLOWUSE=1 and (modu_def.modu_id in ( select modu_id from Modu_Right r where (user_code = 'cailf' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ( (select grop_code from user_group where user_code='cailf'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='cailf' and b.fram_code like a.fram_code || '%')) group by modu_id having max( allow_use) = 1 and max(deny_use) = 0 )) UNION select pers_modu.modu_id, pers_modu.para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, 1 as AllowPersonize, user_modu.modu_type, user_modu.isshowtree, user_modu.sort_id as DashBoardOrder from user_modu, pers_modu where user_modu.modu_type = 1 and user_modu.user_code = 'cailf' and pers_modu.user_code = 'cailf' and user_modu.modu_id = pers_modu.modu_id and (para_id is null ) AND USE_FLAG=1 UNION SELECT modu_id, para_id, Title, Description, DashboardImageLarge, DashboardImageSmall, 1 AS AllowPersonize, 1 AS modu_type, 1 as isshowtree, DashBoardOrder FROM PERS_MODU WHERE MODU_ID NOT IN(SELECT MODU_ID FROM USER_MODU WHERE MODU_TYPE=1 AND USER_CODE='cailf') AND USER_CODE='cailf' order by para_id, DashBoardOrder |
| gdmn0gzvd6psq | Select A.modu_id, A.func_id, A.IsIncluded, A.IsVisible, A.HasFrame, A.AllowRemove, A.AllowMinimize, A.Zone, A.FrameState, A.HeightEnabled, A.Height, A.HeightUnitType, A.WidthEnabled, A.Width, A.WidthUnitType, A.RequiresIsolation, A.RefreshInterval, A.DashboardOrder, 0 as modu_type, 0 as func_type, B.Title AS Title, B.Description AS Description, B.href as href, B.href_desc as href_desc FROM modu_func A, func_def B Where A.func_id = B.func_id and A.modu_id = '0039000200150001' AND (B.func_id in( select func_id from Func_Right r where (user_code = 'maoyuan' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ((select grop_code from user_group where user_code='maoyuan'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='maoyuan' and b.fram_code like a.fram_code || '%')) group by func_id having max( allow_use) = 1 and max(deny_use) = 0 )) ORDER BY A.zone asc, A.DashBoardOrder asc |
| gq94wqrsw7d63 | Select A.modu_id, A.func_id, A.IsIncluded, A.IsVisible, A.HasFrame, A.AllowRemove, A.AllowMinimize, A.Zone, A.FrameState, A.HeightEnabled, A.Height, A.HeightUnitType, A.WidthEnabled, A.Width, A.WidthUnitType, A.RequiresIsolation, A.RefreshInterval, A.DashboardOrder, 0 as modu_type, 0 as func_type, B.Title AS Title, B.Description AS Description, B.href as href, B.href_desc as href_desc FROM modu_func A, func_def B Where A.func_id = B.func_id and A.modu_id = '0046' AND (B.func_id in( select func_id from Func_Right r where (user_code = 'hnqyzxsjs' and user_type = 0 ) or ( user_type = 1 and user_code = 'AllPortalUser') or ( user_type = 1 and user_code IN ((select grop_code from user_group where user_code='hnqyzxsjs'))) or ( user_type =2 and user_code IN ( select a.fram_code from framedepartment a, user_dept b where b.user_code ='hnqyzxsjs' and b.fram_code like a.fram_code || '%')) group by func_id having max( allow_use) = 1 and max(deny_use) = 0 )) ORDER BY A.zone asc, A.DashBoardOrder asc |
| grndn9ax9b4ab | SELECT FLOW_INID, STEP_INCO, FLOW_ID, STEP_CODE, STEP_NAME, STEP_TYPE, SEND_TITL, STEP_MAN, DEAL_EFFE, STEP_CHOI, STEP_LOGI, LOGI_TYPE, NEDE_FLAG, FSUB_ID, FORM_CODE, FSET_FLPE, VALI_SET, TIME_SET, STEP_STAT, CREA_DATE, SAVE_FLAG, SAVE_DATE, SEND_FLAG, SEND_DATE, ENTE_SET, SAVE_SET, SEND_SET, ENTE_COM, SAVE_COM, SEND_COM, NEXT_INCO, PERI_INCO, PERI_MAN, FSUB_INID, SUB_RETU, CIRC_NUM, BTBL_STRU, BACK_FLAG, CANJOIN_FLAG, SUB_WAIT, GENE_STEP_INCO, GENE_DEAL_INDX, GENE_STEP_CODE FROM STEP_INST WHERE FLOW_INID = :1 AND STEP_INCO = :2 |
| gxayy3gfccs4g | select C_FLOW_INID, C_FLOW_INID from YW_ZT_PAY |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 18 | 0.01 | 0.01 |
| Batched IO (full) vector count | 1 | 0.00 | 0.00 |
| Batched IO block miss count | 1,299 | 0.97 | 0.75 |
| Batched IO buffer defrag count | 1 | 0.00 | 0.00 |
| Batched IO double miss count | 154 | 0.11 | 0.09 |
| Batched IO same unit count | 137 | 0.10 | 0.08 |
| Batched IO single block count | 72 | 0.05 | 0.04 |
| Batched IO slow jump count | 1 | 0.00 | 0.00 |
| Batched IO vector block count | 1,033 | 0.77 | 0.60 |
| Batched IO vector read count | 101 | 0.08 | 0.06 |
| Block Cleanout Optim referenced | 44 | 0.03 | 0.03 |
| CCursor + sql area evicted | 99 | 0.07 | 0.06 |
| CPU used by this session | 90,459 | 67.54 | 52.17 |
| CPU used when call started | 89,219 | 66.62 | 51.45 |
| CR blocks created | 3,571 | 2.67 | 2.06 |
| Cached Commit SCN referenced | 399,952 | 298.64 | 230.65 |
| Clusterwide global transactions | 0 | 0.00 | 0.00 |
| Commit SCN cached | 12 | 0.01 | 0.01 |
| DB time | 3,002,298 | 2,241.75 | 1,731.43 |
| DBWR checkpoint buffers written | 4,453 | 3.32 | 2.57 |
| DBWR checkpoints | 5 | 0.00 | 0.00 |
| DBWR fusion writes | 1,879 | 1.40 | 1.08 |
| 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 | 13 | 0.01 | 0.01 |
| DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 73 | 0.05 | 0.04 |
| DBWR undo block writes | 698 | 0.52 | 0.40 |
| DFO trees parallelized | 185 | 0.14 | 0.11 |
| 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 | 268,102,029 | 200,185.80 | 154,614.78 |
| HSC Heap Segment Block Changes | 4,809 | 3.59 | 2.77 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 493 | 0.37 | 0.28 |
| Heap Segment Array Updates | 6 | 0.00 | 0.00 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 129,288 | 96.54 | 74.56 |
| PX local messages recv'd | 7,225 | 5.39 | 4.17 |
| PX local messages sent | 7,225 | 5.39 | 4.17 |
| PX remote messages recv'd | 4,589 | 3.43 | 2.65 |
| PX remote messages sent | 3,194 | 2.38 | 1.84 |
| Parallel operations not downgraded | 185 | 0.14 | 0.11 |
| Requests to/from client | 2,949,550 | 2,202.36 | 1,701.01 |
| RowCR - row contention | 0 | 0.00 | 0.00 |
| RowCR attempts | 856 | 0.64 | 0.49 |
| RowCR hits | 836 | 0.62 | 0.48 |
| SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 2,949,913 | 2,202.63 | 1,701.22 |
| SQL*Net roundtrips to/from dblink | 0 | 0.00 | 0.00 |
| 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 | 752 | 0.56 | 0.43 |
| application wait time | 28 | 0.02 | 0.02 |
| background checkpoints completed | 0 | 0.00 | 0.00 |
| background checkpoints started | 0 | 0.00 | 0.00 |
| background timeouts | 9,416 | 7.03 | 5.43 |
| branch node splits | 1 | 0.00 | 0.00 |
| buffer is not pinned count | 26,583,234 | 19,849.11 | 15,330.58 |
| buffer is pinned count | 36,267,744 | 27,080.31 | 20,915.65 |
| bytes received via SQL*Net from client | 85,422,271 | 63,782.90 | 49,263.13 |
| bytes received via SQL*Net from dblink | 0 | 0.00 | 0.00 |
| bytes sent via SQL*Net to client | 2,304,408,593 | 1,720,650.41 | 1,328,955.36 |
| bytes sent via SQL*Net to dblink | 0 | 0.00 | 0.00 |
| calls to get snapshot scn: kcmgss | 415,151 | 309.98 | 239.42 |
| calls to kcmgas | 30,008 | 22.41 | 17.31 |
| calls to kcmgcs | 1,581,189 | 1,180.64 | 911.87 |
| cell physical IO interconnect bytes | 33,458,430,464 | 24,982,662.49 | 19,295,519.30 |
| change write time | 90 | 0.07 | 0.05 |
| cleanout - number of ktugct calls | 799 | 0.60 | 0.46 |
| cleanouts and rollbacks - consistent read gets | 335 | 0.25 | 0.19 |
| cleanouts only - consistent read gets | 87 | 0.06 | 0.05 |
| cluster key scan block gets | 585,384 | 437.09 | 337.59 |
| cluster key scans | 121,343 | 90.60 | 69.98 |
| cluster wait time | 4,064 | 3.03 | 2.34 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 3 | 0.00 | 0.00 |
| commit batch/immediate requested | 3 | 0.00 | 0.00 |
| commit cleanout failures: block lost | 49 | 0.04 | 0.03 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 10 | 0.01 | 0.01 |
| commit cleanout failures: cannot pin | 1 | 0.00 | 0.00 |
| commit cleanouts | 9,411 | 7.03 | 5.43 |
| commit cleanouts successfully completed | 9,351 | 6.98 | 5.39 |
| commit immediate performed | 3 | 0.00 | 0.00 |
| commit immediate requested | 3 | 0.00 | 0.00 |
| commit txn count during cleanout | 863 | 0.64 | 0.50 |
| concurrency wait time | 5,729,145 | 4,277.82 | 3,304.01 |
| consistent changes | 1,077 | 0.80 | 0.62 |
| consistent gets | 83,199,235 | 62,123.01 | 47,981.10 |
| consistent gets - examination | 17,469,211 | 13,043.87 | 10,074.52 |
| consistent gets direct | 4,072,964 | 3,041.19 | 2,348.88 |
| consistent gets from cache | 79,126,271 | 59,081.82 | 45,632.22 |
| consistent gets from cache (fastpath) | 60,155,282 | 44,916.61 | 34,691.63 |
| cursor authentications | 1,192 | 0.89 | 0.69 |
| data blocks consistent reads - undo records applied | 862 | 0.64 | 0.50 |
| db block changes | 59,924 | 44.74 | 34.56 |
| db block gets | 87,738 | 65.51 | 50.60 |
| db block gets direct | 922 | 0.69 | 0.53 |
| db block gets from cache | 86,816 | 64.82 | 50.07 |
| db block gets from cache (fastpath) | 24,216 | 18.08 | 13.97 |
| deferred (CURRENT) block cleanout applications | 3,132 | 2.34 | 1.81 |
| dirty buffers inspected | 31 | 0.02 | 0.02 |
| enqueue conversions | 1,709 | 1.28 | 0.99 |
| enqueue deadlocks | 0 | 0.00 | 0.00 |
| enqueue releases | 39,980 | 29.85 | 23.06 |
| enqueue requests | 40,012 | 29.88 | 23.07 |
| enqueue timeouts | 18 | 0.01 | 0.01 |
| enqueue waits | 1,043 | 0.78 | 0.60 |
| exchange deadlocks | 1 | 0.00 | 0.00 |
| execute count | 266,599 | 199.06 | 153.75 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io service time | 0 | 0.00 | 0.00 |
| file io wait time | 141,872,750 | 105,933.21 | 81,818.19 |
| free buffer inspected | 17,297 | 12.92 | 9.98 |
| free buffer requested | 25,747 | 19.22 | 14.85 |
| gc blocks compressed | 6,315 | 4.72 | 3.64 |
| gc cr block flush time | 495 | 0.37 | 0.29 |
| gc cr block receive time | 1,490 | 1.11 | 0.86 |
| gc cr blocks received | 7,711 | 5.76 | 4.45 |
| gc cr blocks served | 9,506 | 7.10 | 5.48 |
| gc current block flush time | 129 | 0.10 | 0.07 |
| gc current block pin time | 1 | 0.00 | 0.00 |
| gc current block receive time | 3,365 | 2.51 | 1.94 |
| gc current blocks received | 8,688 | 6.49 | 5.01 |
| gc current blocks served | 7,365 | 5.50 | 4.25 |
| gc kbytes saved | 18,140 | 13.54 | 10.46 |
| gc kbytes sent | 116,828 | 87.23 | 67.37 |
| gc local grants | 2,318 | 1.73 | 1.34 |
| gc read wait time | 40 | 0.03 | 0.02 |
| gc read wait timeouts | 0 | 0.00 | 0.00 |
| gc read waits | 22 | 0.02 | 0.01 |
| gc remote grants | 6,020 | 4.49 | 3.47 |
| gcs messages sent | 38,697 | 28.89 | 22.32 |
| ges messages sent | 6,131 | 4.58 | 3.54 |
| global enqueue get time | 659 | 0.49 | 0.38 |
| global enqueue gets async | 515 | 0.38 | 0.30 |
| global enqueue gets sync | 105,694 | 78.92 | 60.95 |
| global enqueue releases | 110,115 | 82.22 | 63.50 |
| heap block compress | 465 | 0.35 | 0.27 |
| hot buffers moved to head of LRU | 324 | 0.24 | 0.19 |
| immediate (CR) block cleanout applications | 422 | 0.32 | 0.24 |
| immediate (CURRENT) block cleanout applications | 2,248 | 1.68 | 1.30 |
| in call idle wait time | 6,013,667 | 4,490.27 | 3,468.09 |
| index crx upgrade (positioned) | 129,889 | 96.99 | 74.91 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 9,583 | 7.16 | 5.53 |
| index fast full scans (rowid ranges) | 2,080 | 1.55 | 1.20 |
| index fetch by key | 12,252,025 | 9,148.31 | 7,065.76 |
| index scans kdiixs1 | 7,924,687 | 5,917.19 | 4,570.18 |
| leaf node 90-10 splits | 8 | 0.01 | 0.00 |
| leaf node splits | 157 | 0.12 | 0.09 |
| lob reads | 33,566 | 25.06 | 19.36 |
| lob writes | 273 | 0.20 | 0.16 |
| lob writes unaligned | 249 | 0.19 | 0.14 |
| logical read bytes from cache | 648,913,649,664 | 484,529,324.02 | 374,229,325.07 |
| logons cumulative | 5,358 | 4.00 | 3.09 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 7,408 | 5.53 | 4.27 |
| messages sent | 7,408 | 5.53 | 4.27 |
| min active SCN optimization applied on CR | 1 | 0.00 | 0.00 |
| no buffer to keep pinned count | 0 | 0.00 | 0.00 |
| no work - consistent read gets | 63,622,162 | 47,505.25 | 36,690.98 |
| non-idle wait count | 4,107,112 | 3,066.69 | 2,368.58 |
| non-idle wait time | 5,854,795 | 4,371.64 | 3,376.47 |
| opened cursors cumulative | 221,292 | 165.23 | 127.62 |
| parse count (describe) | 38 | 0.03 | 0.02 |
| parse count (failures) | 5 | 0.00 | 0.00 |
| parse count (hard) | 2,612 | 1.95 | 1.51 |
| parse count (total) | 49,137 | 36.69 | 28.34 |
| parse time cpu | 5,744 | 4.29 | 3.31 |
| parse time elapsed | 949,993 | 709.34 | 547.86 |
| physical read IO requests | 133,247 | 99.49 | 76.84 |
| physical read bytes | 33,272,389,632 | 24,843,749.96 | 19,188,229.31 |
| physical read total IO requests | 137,643 | 102.77 | 79.38 |
| physical read total bytes | 33,344,090,624 | 24,897,287.49 | 19,229,579.37 |
| physical read total multi block requests | 10,053 | 7.51 | 5.80 |
| physical reads | 4,061,571 | 3,032.68 | 2,342.31 |
| physical reads cache | 3,882 | 2.90 | 2.24 |
| physical reads cache prefetch | 433 | 0.32 | 0.25 |
| physical reads direct | 4,057,689 | 3,029.79 | 2,340.07 |
| physical reads direct (lob) | 131,632 | 98.29 | 75.91 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 5,533 | 4.13 | 3.19 |
| physical write bytes | 53,460,992 | 39,918.13 | 30,831.02 |
| physical write total IO requests | 10,621 | 7.93 | 6.13 |
| physical write total bytes | 114,339,840 | 85,375.00 | 65,939.93 |
| physical write total multi block requests | 104 | 0.08 | 0.06 |
| physical writes | 6,526 | 4.87 | 3.76 |
| physical writes direct | 922 | 0.69 | 0.53 |
| physical writes direct (lob) | 745 | 0.56 | 0.43 |
| physical writes direct temporary tablespace | 1 | 0.00 | 0.00 |
| physical writes from cache | 5,604 | 4.18 | 3.23 |
| physical writes non checkpoint | 4,315 | 3.22 | 2.49 |
| pinned buffers inspected | 5 | 0.00 | 0.00 |
| pinned cursors current | 68 | 0.05 | 0.04 |
| 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 | 94 | 0.07 | 0.05 |
| process last non-idle time | 1,339 | 1.00 | 0.77 |
| queries parallelized | 185 | 0.14 | 0.11 |
| recovery blocks read | 0 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 568,294 | 424.33 | 327.74 |
| recursive cpu usage | 12,456 | 9.30 | 7.18 |
| redo KB read | 0 | 0.00 | 0.00 |
| redo blocks checksummed by FG (exclusive) | 22,818 | 17.04 | 13.16 |
| redo blocks read for recovery | 0 | 0.00 | 0.00 |
| redo blocks written | 42,012 | 31.37 | 24.23 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 37,211 | 27.78 | 21.46 |
| redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 537 | 0.40 | 0.31 |
| redo size | 20,282,384 | 15,144.40 | 11,696.88 |
| redo size for direct writes | 7,578,032 | 5,658.35 | 4,370.26 |
| redo subscn max counts | 1,120 | 0.84 | 0.65 |
| redo synch long waits | 17 | 0.01 | 0.01 |
| redo synch time | 4,775 | 3.57 | 2.75 |
| redo synch time (usec) | 47,644,885 | 35,575.37 | 27,476.87 |
| redo synch writes | 1,509 | 1.13 | 0.87 |
| redo wastage | 520,004 | 388.28 | 299.89 |
| redo write broadcast ack count | 2 | 0.00 | 0.00 |
| redo write broadcast ack time | 33,579 | 25.07 | 19.37 |
| redo write broadcast lgwr post count | 0 | 0.00 | 0.00 |
| redo write time | 4,741 | 3.54 | 2.73 |
| redo writes | 1,990 | 1.49 | 1.15 |
| rollback changes - undo records applied | 11 | 0.01 | 0.01 |
| rollbacks only - consistent read gets | 33 | 0.02 | 0.02 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 5,966,681 | 4,455.19 | 3,440.99 |
| scheduler wait time | 0 | 0.00 | 0.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 173,366 | 129.45 | 99.98 |
| session logical reads | 83,286,891 | 62,188.46 | 48,031.66 |
| shared hash latch upgrades - no wait | 414,113 | 309.21 | 238.82 |
| shared hash latch upgrades - wait | 1,838 | 1.37 | 1.06 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 337,907 | 252.31 | 194.87 |
| sorts (rows) | 1,970,280 | 1,471.16 | 1,136.26 |
| sql area evicted | 6,535 | 4.88 | 3.77 |
| sql area purged | 5 | 0.00 | 0.00 |
| summed dirty queue length | 55 | 0.04 | 0.03 |
| switch current to new buffer | 1,121 | 0.84 | 0.65 |
| table fetch by rowid | 23,583,339 | 17,609.15 | 13,600.54 |
| table fetch continued row | 383,723 | 286.52 | 221.29 |
| table scan blocks gotten | 47,451,487 | 35,430.97 | 27,365.33 |
| table scan rows gotten | 5,731,370,523 | 4,279,486.32 | 3,305,288.65 |
| table scans (direct read) | 51 | 0.04 | 0.03 |
| table scans (long tables) | 1 | 0.00 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 719,733 | 537.41 | 415.07 |
| temp space allocated (bytes) | 0 | 0.00 | 0.00 |
| total cf enq hold time | 4,318 | 3.22 | 2.49 |
| total number of cf enq holders | 46 | 0.03 | 0.03 |
| total number of times SMON posted | 3 | 0.00 | 0.00 |
| transaction lock background get time | 0 | 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 | 2 | 0.00 | 0.00 |
| 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 | 4,429,304 | 3,307.26 | 2,554.39 |
| user I/O wait time | 30,465 | 22.75 | 17.57 |
| user calls | 3,042,559 | 2,271.81 | 1,754.65 |
| user commits | 1,730 | 1.29 | 1.00 |
| user rollbacks | 4 | 0.00 | 0.00 |
| workarea executions - multipass | 0 | 0.00 | 0.00 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 289,076 | 215.85 | 166.71 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 0 | 0.00 | 0.00 |