oracle 执行计划有多个 child number
答案:1 悬赏:30 手机版
解决时间 2021-02-02 15:48
- 提问者网友：戎马万世
- 2021-02-01 15:15
oracle 执行计划有多个 child number
最佳答案
- 五星知识达人网友：纵马山川剑自提
- 2021-02-01 16:46
It is all about bind values in this case. There are many factors concerning the ability to share a cursor -- and the length of the bind variables can affect this.
Consider this simple example:
ops$tkyte@ORA920> create table t ( x varchar2(2000) );
Table created.
ops$tkyte@ORA920> alter system flush shared_pool;
System altered.
ops$tkyte@ORA920> declare
2 a varchar2(1) := 'x';
3 b varchar2(100) := rpad('x',100,'x');
4 c varchar2(500) := rpad('x',500,'x');
5 d varchar2(1000) := rpad('x',1000,'x');
6 begin
7 insert into t values(a);
8 insert into t values(b);
9 insert into t values(c);
10 insert into t values(d);
11 end;
12 /
PL/SQL procedure successfully completed.
Consider this simple example:
ops$tkyte@ORA920> create table t ( x varchar2(2000) );
Table created.
ops$tkyte@ORA920> alter system flush shared_pool;
System altered.
ops$tkyte@ORA920> declare
2 a varchar2(1) := 'x';
3 b varchar2(100) := rpad('x',100,'x');
4 c varchar2(500) := rpad('x',500,'x');
5 d varchar2(1000) := rpad('x',1000,'x');
6 begin
7 insert into t values(a);
8 insert into t values(b);
9 insert into t values(c);
10 insert into t values(d);
11 end;
12 /
PL/SQL procedure successfully completed.
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯