对于自适应游标共享的一点补充 - 数据库编程

TOP

对于自适应游标共享的一点补充(五)

2014-11-24 03:28:40 来源: 作者: 【大中小】浏览:4次

0 0.000007 0.000017 00000000DD40C0E0 2679189014 082txyqgv2bhq 0 =VR 0 0.000007 0.000008 SQL> exec :vr := 1 PL/SQL 过程已成功完成。 SQL> select /*+ bind_aware */ sum(id) from t1 where rtype = :vr; SUM(ID) ---------- 1 SQL> @show_sql SQL_TEXT EXECUTIONS I I I ------------------------------------------------------------ ---------- - - - select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 1 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 2 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 2 Y Y Y SQL> exec :vr := 8 PL/SQL 过程已成功完成。 SQL> select /*+ bind_aware */ sum(id) from t1 where rtype = :vr; SUM(ID) ---------- 24512 SQL> @show_sql SQL_TEXT EXECUTIONS I I I ------------------------------------------------------------ ---------- - - - select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 1 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 2 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 2 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 1 Y Y Y SQL> @show_sel ADDRESS HASH_VALUE SQL_ID CHILD_NUMBER PREDICATE RANGE_ID LOW HIGH ---------------- ---------- ------------- ------------ ---------------------------------------- ---------- ---------- ---------- 00000000DD40C0E0 2679189014 082txyqgv2bhq 3 =VR 0 0.000007 0.001074 00000000DD40C0E0 2679189014 082txyqgv2bhq 2 =VR 0 0.000007 0.000034 00000000DD40C0E0 2679189014 082txyqgv2bhq 1 =VR 0 0.000007 0.000017 00000000DD40C0E0 2679189014 082txyqgv2bhq 0 =VR 0 0.000007 0.000008 SQL> exec :vr := 14 PL/SQL 过程已成功完成。 SQL> select /*+ bind_aware */ sum(id) from t1 where rtype = :vr; SUM(ID) ---------- 100659200 SQL> @show_sql SQL_TEXT EXECUTIONS I I I ------------------------------------------------------------ ---------- - - - select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 1 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 2 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 2 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 1 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 1 Y Y Y SQL> @show_sel ADDRESS HASH_VALUE SQL_ID CHILD_NUMBER PREDICATE RANGE_ID LOW HIGH ---------------- ---------- ------------- ------------ ---------------------------------------- ---------- ---------- ---------- 00000000DD40C0E0 2679189014 082txyqgv2bhq 4 =VR 0 0.000007 0.068751 00000000DD40C0E0 2679189014 082txyqgv2bhq 3 =VR 0 0.000007 0.001074 00000000DD40C0E0 2679189014 082txyqgv2bhq 2 =VR 0 0.000007 0.000034 00000000DD40C0E0 2679189014 082txyqgv2bhq 1 =VR 0 0.000007 0.000017 00000000DD40C0E0 2679189014 082txyqgv2bhq 0 =VR 0 0.000007 0.000008 SQL> exec :vr := 15 PL/SQL 过程已成功完成。 SQL> select /*+ bind_aware */ sum(id) from t1 where rtype = :vr; SUM(ID) ---------- SQL> @show_sql SQL_TEXT EXECUTIONS I I I ------------------------------------------------------------ ---------- - - - select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 1 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 2 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 2 Y Y N select /*+ bind_aware */ sum(id) from t1 where rtype = :vr 1 Y Y N select /*+ b

首页上一页 2 3 4 5 下一页尾页 5/5/5
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】
分享到:
上一篇：游标cursor	下一篇：PostgreSQL游标使用举例

帐　　号:

密码: (新用户注册)

验证码:

表　　情:

内　　容: