SQL> SELECT substr(sql_text,1,40) "SQL",count(*),sum(executions) "TotExecs"
2 FROM v$sqlarea
3 WHERE executions < 5
4 GROUP BY substr(sql_text,1,40)
5 HAVING count(*) > 30
6 ORDER BY 2;
SQL COUNT(*) TotExecs
-------------------------------------------------------------------------------- ---------- ----------
select count(1),sum(decode(greatest(wpri 33 39
select trim(User_card_ui),trim(User_id_u 33 33
select Zs_ou,Hj_ou,Ks_ou,Date_ou from zl 35 45
update Tp_6cbq set T1_6cbq=1,T2_6cbq=1,T 36 36
select tzdh,tzje,zjje,tzsj,tabFlag,xuhao 39 45
select crow,Tkno_tk2,Date_tk,tmpid,tabFl 39 43
select count(*) from (select Tkno_tk as 40 53
select Seq_tk,Bettype_tk,Multi_tk,money_ 41 50
insert into Zj_Phb_table(Fjje_ph,Id_pn_p 42 83
select Bet_id_tk,trim(Schedule_tk),Betre 43 50
select des_dcs from dg_cshop where Seq_d 43 64
update Tp_14 set S_14=1,P_14=0,F_14=0,Dt 45 45
select folder_ddi from dg_dlinfo where S 46 46
select Seq_dcs,Level_dcs,des_dcs,Type_dc 46 46
select count(*) from dg_event where Even 48 92
select Team1_ev,Team2_ev,Race_name,Res_e 48 92
select season_ss,Lc_ss from zlk_season w 52 85
select Seq_gd,Gk_dh from dg_hmgd,dg_hema 53 53
select count(1),trunc(sum(money_gd),2),t 54 56
update Tp_4 set T0_4=0,T1_4=0,T2_4=1,T3_ 54 54
select sum(Fs_gd),trunc(sum(money_gd),2) 54 56
select Schedule_dh,Syfs_dh,to_char(Cpdt_ 54 56
select Id_pn_gd,Fs_gd,money_gd,trunc(Fs_ 54 56
select Zs_ou,Hj_ou,Ks_ou from zlk_odd_u 58 61
select count(1) from zlk_odd_a where R 59 130
select Num_bf3,Type_bf3 from dg_betinfo3 60 60
select count(1) from dg_max_qihao where 60 102
select trim(User_id_ui),User_card_ui fro 62 95
select * from photowork where seqClassWo 64 180
select money_gd,fjp_gd,Fs_gd from dg_hmg 64 67
select Id_pn_gd,to_char(Date_gd,'yyyy-mm 71 89
update Tp_14 set S_14=2,P_14=0,F_14=0,Dt 72 72
select des_dcs,Father_dcs,Gf_dcs,Level_d 74 222
select Sw1_oa,pk_oa,Sw2_oa,Zhu_oa from z 77 85
select count(*) as num from photowork wh 85 158
update dg_repdata_cw_tmp_1 set Rep_sta_b 95 239
select Seq_tr from zlk_team_rank where 95 380
select Rep_end_balance from dg_repdata_c 95 285
select Rep_sta_balance from dg_repdata_c 95 95
select trim(Yy_tm),trim(En_tm) from zlk_ 100 202
select Event_sche from dg_schedule where 102 190
select Seq_rc,League_rc,Season_rc,Turn_r 103 114
select sum(Tj_Jj_tk) from dg_ticket wher 105 180
select Bet_id_tk,Schedule_tk from dg_tic 105 127
select Multi_tk from dg_ticket where Tkn 107 107
select League_rc,Season_rc,Turn_rc,Date_ 110 127
select count(1),sum(money_tk) from (sele 110 156
select Result_dr,Bettype_dr,Dan_dr,Betid 113 133
update zlk_team_rank set Rank_tr=:1,Jf_t 115 460
select Multi_dr from dg_order where id_d 120 134
select Betid_dr,Schedule_dr,Bettype_dr f 120 134
select Money_dh,Allprize_dh,Yjbl_dh,Fs_d 120 134
select count(*),Ishm_tk from dg_ticket w 123 143
select trim(User_id_ui),trim(User_card_u 124 231
select Gk_dh from dg_hemai where Faid_dh 126 149
select Result_sche from dg_schedule wher 128 255
select count(*),Bet_id_tk from dg_ticket 130 159
select Fs1_dr from dg_order where id_dr= 131 164
select trim(Schedule_dr),trim(Result_dr) 131 158
select Bet_id_tk,Schedule_tk,Bettype_tk, 140 141
select nvl(Date_oa,' '),Sw1_oa,pk_oa,Sw2 141 186
select Num_bf3 from dg_betinfo3 where Be 173 233
select League_rc,Date_rc,Home_rc,Away_rc 178 193
update Tp_6cbq set T1_6cbq=0,T2_6cbq=0,T 180 180
select nvl(Team_tm,' '),nvl(Dc_tm,' '),n 190 435
select Bet_id_tk,trim(Schedule_tk),sum(m 197 253
select Betid_dr,trim(Bettype_dr) from dg 387 649
select Id_pn_tk from dg_ticket where Tkn 409 410
select Status_dh,Syfs_dh,Allprize_dh,hm_ 446 758
select User_id_ui,User_card_ui from user 508 592
select Rank_tr,Jf_tr,Nr_tr,Ns_tr,Np_tr,N 533 673
select League_rc,Date_rc,Home_jq_rc,Home 537 582
select Seq_rc,to_char(Date_rc,'yyyy-mm-d 672 2688
select count(1) from dg_cshop where Fath 689 689
select Status_tk,sum(0) from dg_ticket w 694 894
select sum(money_tk),sum(Tj_Jj_tk),sum(F 732 1055
select Bet_id_tk,Bettype_tk from dg_tick 753 814
select count(*) from dg_ticket where Tkn 833 841
select cmoney,cprice,trunc(cprice/nvl(cm 922 1115
select Sw1_oa,pk_oa,Sw2_oa,Type_oa from 1536 2048
select nvl(Date_ou,' '),Zs_ou,Hj_ou,Ks_o 2042 2374
select max(Date_ou) from zlk_odd_u whe 5786 15678
82 rows selected.
SQL>
这是一条高人交我的如何查看当前时间段的执行的sql是否使用了绑定变量 的一条语句,他没有告诉我怎么从结果来看,请问坛子里的高人,从这个结果中怎么能看出哪条语句没有用到绑定变量呢?