oracle shared pool

最新推荐文章于 2024-08-21 17:13:02 发布

xueaizhong

最新推荐文章于 2024-08-21 17:13:02 发布

阅读量183

点赞数

分类专栏： oracle 文章标签： oracle sql

本文链接：https://blog.csdn.net/xueaizhong/article/details/7712641

版权

oracle 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

共享池的调优
用绑定变量
SQL> var ID varchar2(2);
SQL> exec :ID:='4';

PL/SQL procedure successfully completed.

SQL> select * from aaa where id=:ID;

ID NAME
------ ---------------
4 d

SQL> column NAME for a20
SQL> select name, value from v$sesstat a , v$statname b where a.statistic#=b.statistic# and a.sid=(select sid from v$mystat where rownum=1) and b.name like '%parse%';

NAME                      VALUE
-------------------- ----------
parse time cpu               26
parse time elapsed           32
parse count (total)          39
parse count (hard)           17
parse count (failure          0
s)

不用绑定变量

SQL> select * from aaa where id='4';

ID NAME
------ ---------------
4 d

SQL> column NAME for a20
SQL> select name, value from v$sesstat a , v$statname b where a.statistic#=b.statistic# and a.sid=(select sid from v$mystat where rownum=1) and b.name like '%parse%';

NAME                      VALUE
-------------------- ----------
parse time cpu               31
parse time elapsed           43
parse count (total)          34
parse count (hard)           18
parse count (failure          0
s)

因此要使用绑定变量