| SQL Id | SQL Text |
|---|
| 08znf9a9aankp | select functionpo0_.function_oid as function1_11_0_, functionpo0_.function_parent_oid as function2_11_0_, functionpo0_.function_name as function3_11_0_, functionpo0_.function_show_name as function4_11_0_, functionpo0_.state as state11_0_, functionpo0_.function_type as function6_11_0_, functionpo0_.function_url as function7_11_0_, functionpo0_.function_method as function8_11_0_, functionpo0_.is_root as is9_11_0_, functionpo0_.creater as creater11_0_, functionpo0_.create_time as create11_11_0_, functionpo0_.modifier as modifier11_0_, functionpo0_.modify_time as modify13_11_0_, functionpo0_.remark as remark11_0_, functionpo0_.num as num11_0_, functionpo0_.role_type as role16_11_0_, functionpo0_.ico as ico11_0_, functionpo0_.business_type as business18_11_0_ from t_auth_sys_function functionpo0_ where functionpo0_.function_oid=:1 |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 0v3dvmc22qnam | insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time) |
| 132ty3gcw0pu9 | select AFD020 from FD02 WHERE AAC000=:1 AND ABE010=:2 |
| 13w6ym97xpz3q | select be13po0_.abe130 as abe1_93_, be13po0_.aad040 as aad2_93_, be13po0_.abe010 as abe3_93_, be13po0_.abe132 as abe4_93_, be13po0_.abe133 as abe5_93_, be13po0_.abe134 as abe6_93_, be13po0_.abe135 as abe7_93_, be13po0_.abe136 as abe8_93_, be13po0_.abe137 as abe9_93_, be13po0_.abe138 as abe10_93_, be13po0_.abe139 as abe11_93_, be13po0_.aaa005 as aaa12_93_ from be13 be13po0_ where be13po0_.abe010=:1 |
| 1brfp0mjrk4pa | INSERT INTO DP32 (ADP320, AFD020, AAC000, AAC007, AAB010, AAC002, AAC004, AAC019, AAC028, AAC029, AAD019, AAB017, AAB018, ADP321, AAC005) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15) |
| 1yn3chhb4uctc | select nvl(sum(abe077), 0) as A1Àà,
nvl(sum(abe077), -1) as ÊÇ·ñ´æÔÚA1
from be19 a
where a.abe010 = :1
and a.abe078 = '01'
and a.aac000 = :2
and (a.item_type = '200' or a.item_type = '111')
and exists (select aac000
from be19 b
where a.abe010 = b.abe010
and b.aac000 = :3
and b.abe078 = '01'
and b.item_type = '210') |
| 28p4nc42mub6t | INSERT INTO DP25 (AFD020, ADP250, ADP251, ADP252, ADP253, ADP254, ADP255, ADP260) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8) |
| 2m96px90bfubt | INSERT INTO DP30 (AFD020, AAC076, AAC077, ADE060, AAC071, AAD018, AAD020, AAD019, ADP301, ADP300) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :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 |
| 40jrhfr3qgttr | select a1.aac061,
nvl(a1.aac062, 'NULL') aac062,
nvl(a1.aac063, 'NULL') aac063,
a1.aac066,
a1.aad018,
a1.aad019,
a1.aad020,
a1.aad021,
a1.aac000,
b.abe010,
b.business_type,
sysdate, '522627%' as zoneCode
from ac26 a1, ae05 a2, be01 b
where a1.aae050 = a2.aae050
and a2.abe010 = b.abe010
and (b.business_type in ('110', '120', '140') or
b.business_type like '4%' or b.business_type like '5%' or
b.business_type like '6%')
and b.aaa007>:1 and b.aaa007<:2 and b.aad011 like '522627%'
|
| 4qm1nqsu146cq | INSERT INTO FD12 (AFD120, ADP220, AFD020) VALUES ( :1, :2, :3) |
| 520mkxqpf15q8 | select 1 from dual |
| 56t5muyub4xg9 | select '1' as ÉóÅúIDÊÇ·ñ´æÔÚ
from FD03
where ABE010 = :1
and AAC000=:2 |
| 5darkrucypt3k | select count(distinct(aab010)) AFC082 from FD01 where
aad011 = :1
and ADE010=:2
and ADF010=:3
and ADF020=:4
and ABE071<=201301
and ABE072>=201301
and ade080 not like '2%'
|
| 5m68d60fg0sax | select count(be01po0_.abe010) as col_0_0_ from be01 be01po0_, t_wf_todo twftodopo1_, t_wf_instance twfinstanc2_, t_wf_task_config twftaskcon3_ where twftodopo1_.wf_inst_pk_oid=twfinstanc2_.wf_inst_pk_oid and twfinstanc2_.wf_inst_oid=be01po0_.abe018 and be01po0_.business_type=:1 and be01po0_.abe012=:2 and (twftodopo1_.completed is null) and twftodopo1_.actor_type='02' and (twftodopo1_.actor_oid in (:3)) and twftodopo1_.actor_relaction_org=:4 and twftaskcon3_.wf_config_oid=twfinstanc2_.wf_config_oid and twftaskcon3_.wf_task_name=twftodopo1_.wf_task_name and be01po0_.aad011_sub=:5 and (be01po0_.aad011 like :6) and not (exists (select batchproce4_.abe010 from t_batch_process batchproce4_ where be01po0_.abe010=batchproce4_.abe010)) |
| 5n1830755dutj | select b.abe071 as ´ýÓö¿ªÊ¼Ê±¼ä,
b.abe072 as ´ýÓö½áÊøʱ¼ä,
b.abe077 as ÉóÅú¾ÈÖú½ð¶î,
b.abe073 as ´ýÓöËùÊô,
b.item_type as ¾ÈÖúÏîÄ¿ÀàÐÍ,
b.abe078 as ·¢·ÅÀàÐÍ
from be19 b
where (b.abe078 = '01' or b.abe078 = '02')
and b.abe010 = :1
and b.aac000 = :2 |
| 5r3m95taajvqh | select sum(be08po0_.abe084) as col_0_0_ from be08 be08po0_ where be08po0_.abe010=:1 and be08po0_.abe085<>'03' |
| 64truhtgysgd5 | select aad011 from BI_EXECUTION_PLAN where STATUS = 4 |
| 6tytd6g4jyq1a | select ac01po0_.aac000 as col_0_0_, ac01po0_.aab010 as col_1_0_, ac01po0_.aac002 as col_2_0_, ac01po0_.aac004 as col_3_0_, ac01po0_.aac015 as col_4_0_, ac01po0_.aac013 as col_5_0_, ac02po1_.aac02c as col_6_0_, ac01po0_.aac018 as col_7_0_, ac01po0_.aac009 as col_8_0_, ac01po0_.aac014 as col_9_0_, ac01po0_.aac008 as col_10_0_, ac02po1_.aac021 as col_11_0_, ac02po1_.aac022 as col_12_0_, ac01po0_.aac012 as col_13_0_, ac01po0_.aac010 as col_14_0_, ac01po0_.aac003 as col_15_0_, ac01po0_.aac006 as col_16_0_, ac01po0_.aac017 as col_17_0_ from ac01 ac01po0_, ac02 ac02po1_ where ac01po0_.aab010=:1 and ac01po0_.aac000=ac02po1_.aac000 order by ac01po0_.aac015, ac01po0_.aac002 |
| 71ygfc9jmbru4 | select to_char(a1.AAC076, 'yyyyMMdd') AAC076,
to_char(a1.AAC077, 'yyyyMMdd') AAC077,
a1.AAC072 ADE060,
a1.AAC071,
a1.AAD018,
a1.AAD020,
a1.AAD019,
a1.aac000,
b.business_type,
b.abe010,
sysdate,
'522627%' as zoneCode
from ac27 a1, ae05 a2, be01 b
where a1.aae050 = a2.aae050
and a2.abe010 = b.abe010
and (b.business_type not like '2%' and b.business_type not like '3%')
and b.aaa007>:1 and b.aaa007 < :2 and b.aad011 like '522627%'
|
| 740w5h9rm2u83 | SELECT AAC078 AS ѧҵ״¿ö FROM ac27 WHERE AAE050 = :1 AND AAC000 = :2 |
| 7ac2u6gujmfp0 |
select be01.abe010 as ÉêÇëÉóÅú±àÂë,
be01.aaa006 as ¾°ìÈËÔ±ID,
be01.aab010 as ¼ÒÍ¥ÐÅÏ¢±àÂë,
be01.org_oid as ¾°ì»ú¹¹±àÂë,
be01.aad011 as ÐÐÕþÇø»®±àÂë,
be01.business_type as ¾ÈÖúÒµÎñ±àÂë,
ae05.aae050 as ±ä¸üÐÅÏ¢ID,
ae05.aac016 as µÍ±£Ö¤ºÅ,
be01.aaa005 as µ±Ç°±ê×¼,
nvl(ab21.aab014, 'NULL') as ¼ÒÍ¥Ö÷ÒªÖÂƶÔÒò,
nvl(ab21.aab016, 'NULL') as ¼ÒÍ¥·ÖÀà¾ÈÖúÀà±ð,
nvl(ac22.AAC023, 'NULL') as ²Ð¼²µÈ¼¶,
nvl(ac22.AAC02D, 'NULL') as ÈËÔ±·ÖÀà¾ÈÖúÀà±ð,
nvl(ac21.aac015, 'NULL') as ¼ÒÍ¥¹Øϵ,
nvl(ac21.AAC010, 'NULL') as ÎÄ»¯³Ì¶È,
nvl(ac21.AAC014, 'NULL') as ÊÇ·ñÈýÎÞ,
nvl(ac22.AAC022, 'NULL') as ²Ð¼²Àà±ð,
nvl(ac21.AAC018, 'NULL') as ÈËԱ״̬,
nvl(ac21.AAC012, 'NULL') as ÀͶ¯ÄÜÁ¦,
nvl(ac21.AAC009, 'NULL') as »éÒö×´¿ö,
nvl(ac21.AAC013, 'NULL') as ½¡¿µ×´¿ö,
nvl(ac21.AAC017, 'NULL') as »§¼®ÐÔÖÊ,
nvl(ac21.AAC003, 'NULL') as ÐÔ±ð,
nvl(be01.abe012, '01') as ÒµÎñ°ìÀíÀàÐÍ,
nvl(ac21.AAC008, 'NULL') as ¾ÍÒµ×´¿ö,
nvl(ac21.AAC006, 'NULL') as Ãñ×å,
nvl(ac21.AAC011, 'NULL') as ÕþÖÎÃæò,
ac21.aac000 as ÈËÔ±±àÂë,
nvl(ac22.aac021, '01') as ÊÇ·ñ±£ÕÏ·¶Î§,
ac22.AAC02C as ÄêÊÕÈë,
ac21.AAC005 as ³öÉúÈÕÆÚ_TEMP,
ac21.AAC004 as Éí·ÝÖ¤ºÅÂë,
0 as ÔÂ×ÜÊÕÈë,
'' as ³öÉúÈÕÆÚ,
'NULL' as ÉíÌå×´¿ö,
'14' as ·ÖÀàÊ©±£Àà±ð, --ĬÈÏΪCÀà¶ÔÏó
0 as µ±Ç°±ê×¼½ð¶î,
'' as Ö÷¼ü,
'522627%' as zoneCode
from be01, ae05, ab21, ac21, ac22
where be01.abe010 = ae05.abe010
and be01.business_type = '120'
and ae05.aae0
50=ab21.aae050
and be01.abe019 = '99'
and ae05.aae050=ac21.aae050
and ae05.aae050=ac22.aae050
and ac21.aac000=ac22.aac000
and ab21.aab010=ac21.aab010
-- and ac22.aac021='01'
and be01.aaa007>:1 and be01.aaa007<:2
and be01.aad011 like '522627%'
|
| 7g8gtpdjprx26 | select sm01po0_.asm010 as col_0_0_, sm01po0_.aac000 as col_1_0_, sm01po0_.aab010 as col_2_0_, sm01po0_.aac002 as col_3_0_, sm01po0_.aac004 as col_4_0_, sm01po0_.aac015 as col_5_0_, sm01po0_.aac013 as col_6_0_, sm01po0_.aac02c as col_7_0_, sm01po0_.aac018 as col_8_0_, sm01po0_.aac009 as col_9_0_, sm01po0_.aac014 as col_10_0_, sm01po0_.aac008 as col_11_0_, sm01po0_.aac021 as col_12_0_, sm01po0_.aac022 as col_13_0_, sm01po0_.aac012 as col_14_0_, sm01po0_.aac010 as col_15_0_, sm01po0_.aac003 as col_16_0_, sm01po0_.aac006 as col_17_0_, sm01po0_.aac017 as col_18_0_ from sm01 sm01po0_, sf01 sf01po1_ where sf01po1_.aab010=:1 and sf01po1_.business_type=:2 and sm01po0_.abe010=sf01po1_.abe010 and (sf01po1_.newflag='1' or sf01po1_.newflag='2') and sf01po1_.abe01a=(select max(sf01po2_.abe01a) from sf01 sf01po2_ where sf01po2_.business_type=:3 and sf01po2_.aab010=:4) |
| 8gm0kt2wfvud7 | INSERT INTO FD02 (AFD020, ADP070, ADP310, ADP190, ADP130, ADF020, ADF010, ADP090, ADP080, ADP200, ADP160, ADE080, ADP040, ADP120, ADE010, ADE180, ADE020, ADP060, ADP110, ADP010, ADP020, AAD011, ADP100, ADP330, ADP150, AAC006, ADP140, ADP180, ABE010, AAC000, AAB010, ABE073, ABE077, ABE091, ABE071, ABE072, AAC021, AAC02C, AFD012, AAC016, USER_OID, ORG_CODE, ADF040, ADP210, AFD021, BIZ_PROCESS_TYPE, AFD017, AFD011) 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) |
| 8r8p7g9b6zc7x | INSERT INTO DP29 (ADP290, AAC061, ADP110, ADP120, AAC066, AAD018, AAD019, AAD020, AAD021, ADP291, AFD020) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11) |
| 9wbpyrbm3v1zp | select a1.aac025, a1.aac000, b.abe010, b.business_type, '522627%' as zoneCode
from ac22 a1, ae05 a2, be01 b
where a1.aae050 = a2.aae050
and a2.abe010 = b.abe010
and b.business_type in ('110', '120')
and b.aaa007>:1 and b.aaa007<:2 and b.aad011 like '522627%' |
| b2gnxm5z6r51n | lock table sys.col_usage$ in exclusive mode nowait |
| b68k5dny49gv6 | select be01po0_.business_type as col_0_0_, be01po0_.abe012 as col_1_0_, count(be01po0_.abe010) as col_2_0_ from be01 be01po0_, t_wf_todo twftodopo1_, t_wf_instance twfinstanc2_, t_wf_task_config twftaskcon3_ where twftodopo1_.wf_inst_pk_oid=twfinstanc2_.wf_inst_pk_oid and twfinstanc2_.wf_inst_oid=be01po0_.abe018 and (twftodopo1_.completed is null) and twftodopo1_.actor_type='02' and (twftodopo1_.actor_oid in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22)) and (twftodopo1_.actor_relaction_org=:23 or twftodopo1_.actor_relaction_org is null) and twftaskcon3_.wf_config_oid=twfinstanc2_.wf_config_oid and twftaskcon3_.wf_task_name=twftodopo1_.wf_task_name and (be01po0_.aad011 like :24) group by be01po0_.business_type , be01po0_.abe012 |
| bnrx4fy9ft91k | select AFD030 from FD03 WHERE AAC000=:1 AND ABE010=:2 |
| brwz21favamq0 | select be01po0_.abe010 as col_0_0_ from be01 be01po0_ where be01po0_.business_type=:1 and be01po0_.abe019='99' and be01po0_.aab010=:2 order by be01po0_.abe01a desc |
| bsa0wjtftg3uw | select file# from file$ where ts#=:1 |
| cg31trr3h03jz | select a1.AAB010,
a1.AAC000,
a1.AAC002,
to_char(a1.AAC005, 'yyyyMMdd') as AAC005,
a1.AAC004,
a1.AAC007,
A1.AAC019,
b.abe010,
b.business_type,
a4.aac028,
a4.aac029,
a3.aab017,
a3.aab018,
a3.aad019,
sysdate, '522626%' as zoneCode
from ac21 a1, ae05 a2, ab21 a3, ac22 a4, be01 b
where a1.aae050 = a2.aae050
and a2.aae050 = a3.aae050
and a1.aab010 = a3.aab010
and a1.aae050 = a3.aae050
and a4.aae050 = a2.aae050
and a4.aac000 = a1.aac000
and b.abe010 = a2.abe010
and b.aaa007 > :1 and b.aaa007<:2 and b.aad011 like '522626%'
|
| cm4jzv2t2s19r |
select be01po0_.abe010 as abe1_100_0_, ac01po1_.aac000 as aac1_77_1_, be01po0_.aac000 as aac2_100_0_, be01po0_.aab010 as aab3_100_0_, be01po0_.business_type as business4_100_0_, be01po0_.abe011 as abe5_100_0_, be01po0_.abe012 as abe6_100_0_, be01po0_.abe013 as abe7_100_0_, be01po0_.abe015 as abe8_100_0_, be01po0_.abe016 as abe9_100_0_, be01po0_.abe017 as abe10_100_0_, be01po0_.abe018 as abe11_100_0_, be01po0_.abe019 as abe12_100_0_, be01po0_.aaa005 as aaa13_100_0_, be01po0_.aaa006 as aaa14_100_0_, be01po0_.aad011 as aad15_100_0_, be01po0_.aaa007 as aaa16_100_0_, be01po0_.org_oid as org17_100_0_, be01po0_.abe01a as abe18_100_0_, be01po0_.ace061 as ace19_100_0_, be01po0_.abe01b as abe20_100_0_, be01po0_.check_state as check21_100_0_, be01po0_.import_time as import22_100_0_, be01po0_.check_time as check23_100_0_, be01po0_.aad011_sub as aad24_100_0_, ac01po1_.aab010 as aab2_77_1_, ac01po1_.aac001 as aac3_77_1_, ac01po1_.aac002 as aac4_77_1_, ac01po1_.aac003 as aac5_77_1_, ac01po1_.aac004 as aac6_77_1_, ac01po1_.aac005 as aac7_77_1_, ac01po1_.aac006 as aac8_77_1_, ac01po1_.aac007 as aac9_77_1_, ac01po1_.aac008 as aac10_77_1_, ac01po1_.aac009 as aac11_77_1_, ac01po1_.aac010 as aac12_77_1_, ac01po1_.aac011 as aac13_77_1_, ac01po1_.aac012 as aac14_77_1_, ac01po1_.aac013 as aac15_77_1_, ac01po1_.aac014 as aac16_77_1_, ac01po1_.aac015 as aac17_77_1_, ac01po1_.aac016 as aac18_77_1_, ac01po1_.aac017 as aac19_77_1_, ac01po1_.aac018 as aac20_77_1_
, ac01po1_.aac019 as aac21_77_1_, ac01po1_.aaa005 as aaa22_77_1_, ac01po1_.aaa006 as aaa23_77_1_, ac01po1_.aaa007 as aaa24_77_1_, ac01po1_.aad011 as aad25_77_1_, ac01po1_.org_oid as org26_77_1_ from be01 be01po0_, ac01 ac01po1_ where be01po0_.abe010=:1 and be01po0_.aab010=ac01po1_.aab010 and ac01po1_.aac018='01' |
| ctwwmgnm410pq | select a1.AAB010,
a1.AAC000,
a1.AAC002,
to_char(a1.AAC005, 'yyyyMMdd') as AAC005,
a1.AAC004,
a1.AAC007,
A1.AAC019,
b.abe010,
b.business_type,
a4.aac028,
a4.aac029,
a3.aab017,
a3.aab018,
a3.aad019,
sysdate, '522627%' as zoneCode
from ac21 a1, ae05 a2, ab21 a3, ac22 a4, be01 b
where a1.aae050 = a2.aae050
and a2.aae050 = a3.aae050
and a1.aab010 = a3.aab010
and a1.aae050 = a3.aae050
and a4.aae050 = a2.aae050
and a4.aac000 = a1.aac000
and b.abe010 = a2.abe010
and b.aaa007 > :1 and b.aaa007<:2 and b.aad011 like '522627%'
|
| d7pct4f1s3y94 |
select * from ( select '' as col_0_0_, '' as col_1_0_, be01po0_.abe010 as col_2_0_, be01po0_.abe016 as col_3_0_, twftodopo1_.wf_task_oid as col_4_0_, twftodopo1_.wf_task_name as col_5_0_, twftodopo1_.started as col_6_0_, twftodopo1_.state as col_7_0_, twfinstanc2_.wf_config_oid as col_8_0_, twftaskcon3_.time_limit as col_9_0_, twftaskcon3_.form_oid as col_10_0_, be01po0_.aac000 as col_11_0_, be01po0_.aab010 as col_12_0_, be01po0_.abe019 as col_13_0_, be01po0_.aad011 as col_14_0_, 0 as col_15_0_, be01po0_.check_state as col_16_0_, be01po0_.import_time as col_17_0_, be01po0_.check_time as col_18_0_ from be01 be01po0_, t_wf_todo twftodopo1_, t_wf_instance twfinstanc2_, t_wf_task_config twftaskcon3_ where twftodopo1_.wf_inst_pk_oid=twfinstanc2_.wf_inst_pk_oid and twfinstanc2_.wf_inst_oid=be01po0_.abe018 and be01po0_.business_type=:1 and be01po0_.abe012=:2 and (twftodopo1_.completed is null) and twftodopo1_.actor_type='02' and (twftodopo1_.actor_oid in (:3)) and twftodopo1_.actor_relaction_org=:4 and twftaskcon3_.wf_config_oid=twfinstanc2_.wf_config_oid and twftaskcon3_.wf_task_name=twftodopo1_.wf_task_name and be01po0_.aad011_sub=:5 and (be01po0_.aad011 like :6) and not (exists (select batchproce4_.abe010 from t_batch_process batchproce4_ where be01po0_.abe010=batchproce4_.abe010)) order by be01po0_.abe016 ) where rownum <= :7
|
| da2mydrqz6hdy | select nvl(a1.aac051 , 'NULL') as ÊÕÈëÀàÐÍ,
a1.AAC053 as ÔÂÊÕÈë,
a1.aac055 as Ô¼ÆÈëÊÕÈë,
a1.aac000,
b.business_type,
b.abe010,
0 as ÄêÊÕÈë,
0 as Äê¼ÆÈëÊÕÈë,
sysdate, '522627%' as zoneCode
from ac25 a1, ae05 a2, be01 b
where a1.aae050 = a2.aae050
and a2.abe010 = b.abe010
and b.aaa007 >:1 and b.aaa007<:2 and b.aad011 like '522627%' |
| db7ba7pf2q467 | update t_form_config
set parameters = 'ABE010;orgOid;businessType;dataFlag;checkFalg;ABE019;AAB010'
where form_oid in ('DA71A34500654018BA8DC1EF16FCF760',
'8DF9625106674A61A6FFA4C714C7E2F8',
'D1A9EF5DCD5449EE82CD178F08E12E71') |
| fr04xnkx96jgc | SELECT AAC091 AS ±ä»¯ÀàÐÍ, ABE091 AS ±ä»¯½ð¶î, ABE093 AS ±ä»¯ÈÕÆÚ FROM be09 WHERE AAC000 = :1 AND ABE010 = :2 AND AAC091 <> :3 |
| g295h1jz7b962 | select count(sf01po0_.abe010) as col_0_0_ from sf01 sf01po0_, be08 be08po1_ where sf01po0_.abe010=be08po1_.abe010 and sf01po0_.aab010=be08po1_.aab010 and be08po1_.abe085='01' and be08po1_.business_type=:1 and (sf01po0_.aad011 like :2) and sf01po0_.aad011_sub=:3 and be08po1_.aad011_sub=:4 and be08po1_.abe081<=:5 and be08po1_.abe082>=:6 |
| gk3yczr2ms0b2 | SELECT AAC062 AS µ¥Î»ÐÔÖÊ, AAC064 AS Á¥Êô¹Øϵ FROM ac26 WHERE AAE050 = :1 AND AAC000 = :2 |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 1,850 | 0.51 | 0.58 |
| Batched IO (full) vector count | 481 | 0.13 | 0.15 |
| Batched IO (space) vector count | 5 | 0.00 | 0.00 |
| Batched IO block miss count | 332,420 | 91.99 | 104.30 |
| Batched IO buffer defrag count | 1,396 | 0.39 | 0.44 |
| Batched IO double miss count | 3,424 | 0.95 | 1.07 |
| Batched IO same unit count | 79,647 | 22.04 | 24.99 |
| Batched IO single block count | 172 | 0.05 | 0.05 |
| Batched IO slow jump count | 1,388 | 0.38 | 0.44 |
| Batched IO vector block count | 253,071 | 70.03 | 79.41 |
| Batched IO vector read count | 2,282 | 0.63 | 0.72 |
| CCursor + sql area evicted | 0 | 0.00 | 0.00 |
| CPU used by this session | 27,316 | 7.56 | 8.57 |
| CPU used when call started | 26,745 | 7.40 | 8.39 |
| CR blocks created | 8,054 | 2.23 | 2.53 |
| Cached Commit SCN referenced | 8,775 | 2.43 | 2.75 |
| Commit SCN cached | 5 | 0.00 | 0.00 |
| DB time | 1,633,599 | 452.05 | 512.58 |
| DBWR checkpoint buffers written | 760,630 | 210.48 | 238.67 |
| DBWR checkpoints | 35 | 0.01 | 0.01 |
| 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 | 670,560 | 185.56 | 210.40 |
| DBWR transaction table writes | 265 | 0.07 | 0.08 |
| DBWR undo block writes | 86,298 | 23.88 | 27.08 |
| Effective IO time | 0 | 0.00 | 0.00 |
| HSC Heap Segment Block Changes | 173,523 | 48.02 | 54.45 |
| Heap Segment Array Inserts | 22,957 | 6.35 | 7.20 |
| Heap Segment Array Updates | 260 | 0.07 | 0.08 |
| IMU CR rollbacks | 26 | 0.01 | 0.01 |
| IMU Flushes | 715 | 0.20 | 0.22 |
| IMU Redo allocation size | 7,794,840 | 2,157.00 | 2,445.82 |
| IMU commits | 86 | 0.02 | 0.03 |
| IMU contention | 0 | 0.00 | 0.00 |
| IMU ktichg flush | 0 | 0.00 | 0.00 |
| IMU pool not allocated | 1,638 | 0.45 | 0.51 |
| IMU recursive-transaction flush | 1 | 0.00 | 0.00 |
| IMU undo allocation size | 1,646,432 | 455.60 | 516.61 |
| IMU- failed to get a private strand | 1,638 | 0.45 | 0.51 |
| LOB table id lookup cache misses | 124 | 0.03 | 0.04 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 0 | 0.00 | 0.00 |
| RowCR - row contention | 0 | 0.00 | 0.00 |
| RowCR attempts | 123 | 0.03 | 0.04 |
| RowCR hits | 123 | 0.03 | 0.04 |
| SMON posted for undo segment shrink | 31 | 0.01 | 0.01 |
| SQL*Net roundtrips to/from client | 1,520,237 | 420.68 | 477.01 |
| active txn count during cleanout | 41,003 | 11.35 | 12.87 |
| application wait time | 1,057,349 | 292.59 | 331.77 |
| auto extends on undo tablespace | 0 | 0.00 | 0.00 |
| background checkpoints completed | 36 | 0.01 | 0.01 |
| background checkpoints started | 35 | 0.01 | 0.01 |
| background timeouts | 13,897 | 3.85 | 4.36 |
| branch node splits | 56 | 0.02 | 0.02 |
| buffer is not pinned count | 9,133,695 | 2,527.48 | 2,865.92 |
| buffer is pinned count | 20,811,971 | 5,759.11 | 6,530.27 |
| bytes received via SQL*Net from client | 352,246,388 | 97,473.95 | 110,526.01 |
| bytes sent via SQL*Net to client | 241,390,423 | 66,797.78 | 75,742.21 |
| calls to get snapshot scn: kcmgss | 1,533,291 | 424.29 | 481.11 |
| calls to kcmgas | 117,843 | 32.61 | 36.98 |
| calls to kcmgcs | 18,625 | 5.15 | 5.84 |
| calls to kcmgrs | 5,463,699 | 1,511.92 | 1,714.37 |
| change write time | 2,132 | 0.59 | 0.67 |
| cleanout - number of ktugct calls | 63,264 | 17.51 | 19.85 |
| cleanouts and rollbacks - consistent read gets | 7,806 | 2.16 | 2.45 |
| cleanouts only - consistent read gets | 991 | 0.27 | 0.31 |
| cluster key scan block gets | 1,696 | 0.47 | 0.53 |
| cluster key scans | 1,069 | 0.30 | 0.34 |
| commit batch/immediate performed | 149 | 0.04 | 0.05 |
| commit batch/immediate requested | 149 | 0.04 | 0.05 |
| commit cleanout failures: block lost | 2,559 | 0.71 | 0.80 |
| commit cleanout failures: buffer being written | 2,309 | 0.64 | 0.72 |
| commit cleanout failures: callback failure | 2,848 | 0.79 | 0.89 |
| commit cleanout failures: cannot pin | 2 | 0.00 | 0.00 |
| commit cleanouts | 1,747,000 | 483.43 | 548.16 |
| commit cleanouts successfully completed | 1,739,282 | 481.30 | 545.74 |
| commit immediate performed | 149 | 0.04 | 0.05 |
| commit immediate requested | 149 | 0.04 | 0.05 |
| commit txn count during cleanout | 39,873 | 11.03 | 12.51 |
| concurrency wait time | 204 | 0.06 | 0.06 |
| consistent changes | 24,332 | 6.73 | 7.63 |
| consistent gets | 25,850,644 | 7,153.41 | 8,111.28 |
| consistent gets - examination | 5,325,787 | 1,473.76 | 1,671.10 |
| consistent gets direct | 1 | 0.00 | 0.00 |
| consistent gets from cache | 25,850,639 | 7,153.41 | 8,111.28 |
| consistent gets from cache (fastpath) | 19,346,163 | 5,353.49 | 6,070.34 |
| current blocks converted for CR | 0 | 0.00 | 0.00 |
| cursor authentications | 580 | 0.16 | 0.18 |
| data blocks consistent reads - undo records applied | 23,181 | 6.41 | 7.27 |
| db block changes | 5,521,408 | 1,527.89 | 1,732.48 |
| db block gets | 7,546,620 | 2,088.31 | 2,367.94 |
| db block gets direct | 79 | 0.02 | 0.02 |
| db block gets from cache | 7,546,541 | 2,088.29 | 2,367.91 |
| db block gets from cache (fastpath) | 2,302,657 | 637.19 | 722.52 |
| deferred (CURRENT) block cleanout applications | 1,315,013 | 363.89 | 412.62 |
| dirty buffers inspected | 51,056 | 14.13 | 16.02 |
| drop segment calls in space pressure | 0 | 0.00 | 0.00 |
| enqueue conversions | 991 | 0.27 | 0.31 |
| enqueue deadlocks | 0 | 0.00 | 0.00 |
| enqueue releases | 138,862 | 38.43 | 43.57 |
| enqueue requests | 138,868 | 38.43 | 43.57 |
| enqueue timeouts | 5 | 0.00 | 0.00 |
| enqueue waits | 67 | 0.02 | 0.02 |
| exchange deadlocks | 0 | 0.00 | 0.00 |
| execute count | 1,437,716 | 397.85 | 451.12 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| free buffer inspected | 1,265,532 | 350.20 | 397.09 |
| free buffer requested | 1,249,814 | 345.85 | 392.16 |
| heap block compress | 90 | 0.02 | 0.03 |
| hot buffers moved to head of LRU | 997,626 | 276.06 | 313.03 |
| immediate (CR) block cleanout applications | 8,797 | 2.43 | 2.76 |
| immediate (CURRENT) block cleanout applications | 67,817 | 18.77 | 21.28 |
| index crx upgrade (found) | 249 | 0.07 | 0.08 |
| index crx upgrade (positioned) | 2 | 0.00 | 0.00 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 1 | 0.00 | 0.00 |
| index fetch by key | 189,263 | 52.37 | 59.39 |
| index scans kdiixs1 | 3,589,842 | 993.38 | 1,126.40 |
| java call heap collected bytes | 0 | 0.00 | 0.00 |
| java call heap collected count | 0 | 0.00 | 0.00 |
| java call heap gc count | 0 | 0.00 | 0.00 |
| java call heap live object count | 0 | 0.00 | 0.00 |
| java call heap live object count max | 0 | 0.00 | 0.00 |
| java call heap live size | 0 | 0.00 | 0.00 |
| java call heap live size max | 0 | 0.00 | 0.00 |
| java call heap object count | 0 | 0.00 | 0.00 |
| java call heap object count max | 0 | 0.00 | 0.00 |
| java call heap total size | 0 | 0.00 | 0.00 |
| java call heap total size max | 0 | 0.00 | 0.00 |
| java call heap used size | 0 | 0.00 | 0.00 |
| java call heap used size max | 0 | 0.00 | 0.00 |
| leaf node 90-10 splits | 168 | 0.05 | 0.05 |
| leaf node splits | 22,063 | 6.11 | 6.92 |
| lob reads | 98 | 0.03 | 0.03 |
| lob writes | 263 | 0.07 | 0.08 |
| lob writes unaligned | 263 | 0.07 | 0.08 |
| local undo segment hints helped | 0 | 0.00 | 0.00 |
| logons cumulative | 33 | 0.01 | 0.01 |
| messages received | 67,952 | 18.80 | 21.32 |
| messages sent | 67,952 | 18.80 | 21.32 |
| no buffer to keep pinned count | 77 | 0.02 | 0.02 |
| no work - consistent read gets | 20,410,234 | 5,647.94 | 6,404.22 |
| opened cursors cumulative | 27,025 | 7.48 | 8.48 |
| parse count (failures) | 3 | 0.00 | 0.00 |
| parse count (hard) | 1,007 | 0.28 | 0.32 |
| parse count (total) | 25,345 | 7.01 | 7.95 |
| parse time cpu | 32 | 0.01 | 0.01 |
| parse time elapsed | 411 | 0.11 | 0.13 |
| physical read IO requests | 1,032,021 | 285.58 | 323.82 |
| physical read bytes | 9,171,460,096 | 2,537,935.01 | 2,877,772.23 |
| physical read total IO requests | 1,273,793 | 352.49 | 399.68 |
| physical read total bytes | 13,130,999,808 | 3,633,622.54 | 4,120,175.65 |
| physical read total multi block requests | 800 | 0.22 | 0.25 |
| physical reads | 1,119,563 | 309.81 | 351.29 |
| physical reads cache | 1,118,410 | 309.49 | 350.93 |
| physical reads cache prefetch | 348,167 | 96.35 | 109.25 |
| physical reads direct | 1,153 | 0.32 | 0.36 |
| physical reads direct (lob) | 0 | 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 | 479,681 | 132.74 | 150.51 |
| physical write bytes | 7,320,788,992 | 2,025,815.57 | 2,297,078.44 |
| physical write total IO requests | 491,466 | 136.00 | 154.21 |
| physical write total bytes | 8,851,350,528 | 2,449,353.99 | 2,777,329.94 |
| physical write total multi block requests | 9,690 | 2.68 | 3.04 |
| physical writes | 893,651 | 247.29 | 280.41 |
| physical writes direct | 1,231 | 0.34 | 0.39 |
| physical writes direct (lob) | 1 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 892,420 | 246.95 | 280.02 |
| physical writes non checkpoint | 379,067 | 104.90 | 118.94 |
| pinned buffers inspected | 54 | 0.01 | 0.02 |
| 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 | 12,106 | 3.35 | 3.80 |
| recursive calls | 94,232 | 26.08 | 29.57 |
| recursive cpu usage | 697 | 0.19 | 0.22 |
| redo blocks checksummed by FG (exclusive) | 947,165 | 262.10 | 297.20 |
| redo blocks written | 2,775,948 | 768.16 | 871.02 |
| redo blocks written for direct writes | 260 | 0.07 | 0.08 |
| redo buffer allocation retries | 748 | 0.21 | 0.23 |
| redo entries | 2,836,663 | 784.96 | 890.07 |
| redo log space requests | 79,641 | 22.04 | 24.99 |
| redo log space wait time | 24,304 | 6.73 | 7.63 |
| redo ordering marks | 83,099 | 23.00 | 26.07 |
| redo size | 1,378,015,936 | 381,325.86 | 432,386.55 |
| redo subscn max counts | 142,592 | 39.46 | 44.74 |
| redo synch time | 2,323 | 0.64 | 0.73 |
| redo synch writes | 2,026 | 0.56 | 0.64 |
| redo wastage | 1,236,520 | 342.17 | 387.99 |
| redo write time | 4,177 | 1.16 | 1.31 |
| redo writer latching time | 0 | 0.00 | 0.00 |
| redo writes | 3,592 | 0.99 | 1.13 |
| rollback changes - undo records applied | 308 | 0.09 | 0.10 |
| rollbacks only - consistent read gets | 166 | 0.05 | 0.05 |
| rows fetched via callback | 185,802 | 51.42 | 58.30 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 21,649 | 5.99 | 6.79 |
| session logical reads | 33,397,501 | 9,241.79 | 10,479.29 |
| shared hash latch upgrades - no wait | 45,172 | 12.50 | 14.17 |
| shared hash latch upgrades - wait | 253 | 0.07 | 0.08 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 105,559 | 29.21 | 33.12 |
| sorts (rows) | 780,342 | 215.94 | 244.85 |
| space was found by tune down | 0 | 0.00 | 0.00 |
| sql area evicted | 903 | 0.25 | 0.28 |
| sql area purged | 3 | 0.00 | 0.00 |
| steps of tune down ret. in space pressure | 0 | 0.00 | 0.00 |
| summed dirty queue length | 141,422 | 39.13 | 44.37 |
| switch current to new buffer | 870 | 0.24 | 0.27 |
| table fetch by rowid | 13,071,496 | 3,617.16 | 4,101.50 |
| table fetch continued row | 289 | 0.08 | 0.09 |
| table scan blocks gotten | 11,859,986 | 3,281.91 | 3,721.36 |
| table scan rows gotten | 277,764,207 | 76,863.17 | 87,155.38 |
| table scans (direct read) | 0 | 0.00 | 0.00 |
| table scans (long tables) | 3 | 0.00 | 0.00 |
| table scans (short tables) | 11,208 | 3.10 | 3.52 |
| total number of times SMON posted | 31 | 0.01 | 0.01 |
| transaction rollbacks | 149 | 0.04 | 0.05 |
| transaction tables consistent read rollbacks | 1 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 486 | 0.13 | 0.15 |
| tune down retentions in space pressure | 0 | 0.00 | 0.00 |
| undo change vector size | 504,458,920 | 139,594.34 | 158,286.45 |
| user I/O wait time | 1,508,755 | 417.50 | 473.41 |
| user calls | 1,539,731 | 426.08 | 483.13 |
| user commits | 1,905 | 0.53 | 0.60 |
| user rollbacks | 1,282 | 0.35 | 0.40 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 33,356 | 9.23 | 10.47 |
| write clones created in background | 5 | 0.00 | 0.00 |
| write clones created in foreground | 634 | 0.18 | 0.20 |