???????????????????????????????????????????LOADRUNNER??????????????????Щ??????????????????????????????????????????????????

?????????????????????????????????????????????????????????????????????????????Щ?д?????????￡?????????????ο???

??????????????????????????SAFS??STAF?????????????????????????????????????????????????????4??????и???????????????

???????е???е??????????????????????????????????????????????????????????????????????????????????????????????????

?????????????????Щ????????д???????????????г???????????????Щ???????????????????????????????????????????????????????????

?????????????????????У????????и????????????DBA?????????????????????????????????????????????????????У?????????±?д???????

????????????????????????????????仺????????????ж??????????????????????????????????????в?????????????????SQL????????

????????????е?SQL?????select sql_text??sql_id??users_executing??executions?? loads from v$sqlarea;??????????????е?SQL??????????SQL_ID???SQL???

????select * from v$sqltext where sql_id =??75yzszjxyrrva??????????HASH_VALUE?????????SQL??select * from v$sql where hash_value=??2079055722??.????SQL????

????????SQL??????н?????

1??select b.case_id??report_no??report_time??b.organ_id??realname??accident_time?? reporter_name??accident_type??certi_type??register_id?? recorder_id??  certi_code??  accident_status?? has_image?? accident_type?? diff_date??   to_char(max(ti2.scan_time)?? ??YYYY-MM-DD HH24:MI:ss??) as scan_time from (  select distinct tcc.case_id??tcc.case_no as report_no??tcc.report_time??tcu.real_name as realname??tcc.accident_type?? tcc.accident_time??tcc.register_id??tcc.reporter_name??trc.certi_type??trc.certi_code??tcc.accident_status??tcc.recorder_id??tcc.organ_id??tcc.case_type??  sysdate - trc.insert_time as diff_date??decode(ti.case_id?? null?? -1?? 1) as has_image  from t_report_case trc ??t_claim_case tcc??t_customer tcu??t_image ti ??t_employee te where trc.case_id = tcc.case_id  and tcc.case_id = ti.case_id(+)  and tcc.register_id = te.emp_id  and tcc.register_id = 3381221 and tcc.insured_id = tcu.customer_id(+)  and tcc.case_status=4  and tcc.case_type = te.case_type   )b  ?? t_image ti2 where ti2.case_id(+)=b.case_id     group by b.case_id??report_no??  report_time??      b.organ_id??       realname??       accident_time??       reporter_name??       accident_type??       certi_type??       register_id??       recorder_id??       certi_code??       accident_status??       has_image??     accident_type??       diff_date order by has_image desc??report_time asc

??????????6.672??

2??(   select tpp.prem_id??tpp.policy_id??tpp.fee_type??tpp.pay_mode??           tpp.fee_status??tpp.actual_prem??tpp.due_time??tgp.holder_id as customer_id??           tgp.send_code??tgp.policy_code as policy_code?? tpp.policy_type??          tpp.insured_id??tif.insured_num???? ?? as notice_code      from t_policy_prem tpp??t_group_policy tgp??t_insured_first tif    where  ((tpp.fee_status=0 and tpp.pay_mode in(1??2))or(tpp.fee_status in(0??3??4) and tpp.pay_mode=3))      and tpp.fee_type= :1      and tpp.insured_id=tif.insured_id(+)      and tpp.policy_id=tif.policy_id(+)      and tpp.policy_type = ??2??      and tpp.policy_id = tgp.policy_id      and tgp.send_code = :2  )  union  (   select tpp.prem_id??tpp.policy_id??tpp.fee_type??tpp.pay_mode??           tpp.fee_status??tpp.actual_prem??tpp.due_time??tp.holder_id as customer_id??           tp.send_code??tp.policy_code??tpp.policy_type??           tpp.insured_id??tp.insurant_num as insured_num???? ?? as notice_code      from t_policy_prem tpp??t_policy tp    where 1=1      and  ((tpp.fee_status=0 and tpp.pay_mode in(1??2))or(tpp.fee_status in(0??3??4) and tpp.pay_mode=3))      and tpp.insured_id is null      and tpp.policy_type in (??1??????3??)      and tpp.fee_type= :3      and tp.send_code = :4       and tpp.policy_id = tp.policy_id     )    order by due_time??fee_type

??????????4.8?????????????????SQL??????м????SQL1??COST???????????????SQL2??COST?????1700??????????????????SQL???????????????SQL1??

??????????????select b.case_id??report_no??report_time??b.organ_id??realname??accident_time?? reporter_name??accident_type??certi_type??register_id?? recorder_id??  certi_code??  accident_status?? has_image?? accident_type?? diff_date??   to_char(max(scan_time)?? ??YYYY-MM-DD HH24:MI:ss??) as scan_time from (  select distinct tcc.case_id??tcc.case_no as report_no??tcc.report_time??tcu.real_name as realname??tcc.accident_type?? tcc.accident_time??tcc.register_id??tcc.reporter_name??trc.certi_type??trc.certi_code??tcc.accident_status??tcc.recorder_id??tcc.organ_id??tcc.case_type??  sysdate - trc.insert_time as diff_date??decode(ti.case_id?? null?? -1?? 1) as has_image??scan_time  from t_report_case trc ??t_claim_case tcc??t_customer tcu??t_image ti ??t_employee te where trc.case_id = tcc.case_id  and tcc.case_id = ti.case_id(+)  and tcc.register_id = te.emp_id  and tcc.register_id = 3381221 and tcc.insured_id = tcu.customer_id(+)  and tcc.case_status=4  and tcc.case_type = te.case_type   )b       group by b.case_id??report_no??  report_time??      b.organ_id??       realname??       accident_time??       reporter_name??       accident_type??       certi_type??       register_id??       recorder_id??       certi_code??       accident_status??       has_image??     accident_type??       diff_date order by has_image desc??report_time asc

?????????????????0.047???????

?????????SQL????鷳??????t????????????????????????????????????????