[20210818]测试sql语句子光标的性能4.txt

来源：这里教程网时间：2026-03-03 16:53:50 作者：

[20210818]测试sql语句子光标的性能4.txt --//如果一条sql语句产生的子光标很多,除了消耗共享池内存外,也会导致执行时一些性能问题.测试看看. --//children number=0 与children number=127执行时是否存在差异. --//前几天的测试链接:http://blog.itpub.net/267265/viewspace-2786553/=>[20210812]测试sql语句子光标的性能.txt, --//可以发现children number=127的在session_cached_cursors=0的情况下比children number=0的快许多. --//今天测试如果中间的子光标消失的情况。 1.环境: SCOTT@book> @ ver1 PORT_STRING VERSION BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production SYS@book> @ hide _cursor_obsolete_threshold NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE ISSES ISSYS_MOD --------------------------- ----------------------------------------------- ------------- ------------- ------------ ----- --------- _cursor_obsolete_threshold Number of cursors per parent before obsoletion. TRUE 1024 1024 TRUE FALSE SYS@book> alter system set session_cached_cursors=0 scope=spfile; System altered. --//重启略. --//设置session_cache_cursor=0;避免通过软软解析，主要想看看这种方式对性能的影响，我想了解寻找合适的执行计划是否通过探察。 --//如果设置session_cache_cursor>0,通过软软解析，2种情况执行效率基本一样，没有差别大家可以自行测试。 2.建立测试环境: create table job_times (sid number, time_ela number,method varchar2(20)); create table t as select rownum id ,cast('test' as varchar2(10)) name from dual ; alter table t modify ( id not null ); create unique index i_t_id on t(id); --//分析表略。 --//产生128个子光标. $ cat m13.txt set verify off --//host sleep $(echo &&3/50 | bc -l ) variable vmethod varchar2(20); exec :vmethod := '&&2'; --//insert into job_times values ( sys_context ('userenv', 'sid') ,dbms_utility.get_time ,:vmethod) ; commit ; alter session set optimizer_index_cost_adj = &&3; declare v_id number; v_d date; l_count PLS_INTEGER; begin for i in 1 .. &&1 loop --//execute immediate 'select count(name) from t where id=1' into l_count; SELECT COUNT(NAME) INTO v_id FROM T WHERE ID=1; end loop; end ; / --//update job_times set time_ela = dbms_utility.get_time - time_ela where sid=sys_context ('userenv', 'sid') and method=:vmethod; --//commit; quit --//说明：参数1表示循环次数，参数2表示method，参数3表示设置optimizer_index_cost_adj。 $ seq 6 | xargs -IZ bash -c "seq 128 | xargs -IQ sqlplus -s -l scott/book @m13.txt 1 xx Q > /dev/null" --//执行6次,保证其在共享池中.sql_id='5zfc9hksnyp90',注意sql语句全部大写，因为PL/SQL内部做了转化为大写。 SCOTT@book> select child_number,executions from v$sql where sql_id='5zfc9hksnyp90' and child_number in (0,127); CHILD_NUMBER EXECUTIONS ------------ ---------- 0 6 127 6 SCOTT@book> select count(*) from v$sql where sql_id='5zfc9hksnyp90'; COUNT(*) ---------- 128 $ cat m12.txt set verify off host sleep $(echo &&3/150 | bc -l ) variable vmethod varchar2(20); exec :vmethod := '&&2'; insert into job_times values ( sys_context ('userenv', 'sid') ,dbms_utility.get_time ,:vmethod) ; commit ; alter session set optimizer_index_cost_adj = &&4; declare v_id number; v_d date; l_count PLS_INTEGER; begin for i in 1 .. &&1 loop --//execute immediate 'select count(name) from t where id=1' into l_count; SELECT COUNT(NAME) INTO v_id FROM T WHERE ID=1; end loop; end ; / update job_times set time_ela = dbms_utility.get_time - time_ela where sid=sys_context ('userenv', 'sid') and method=:vmethod; commit; quit --//说明：参数1表示循环次数，参数2表示method，参数3表示设置延迟，避免开始同时执行的一些争用,参数4设置optimizer_index_cost_adj. 3.测试: $ cat ee2.sh #!! /bin/bash zzdate;seq 150 | xargs -I{} -P 150 sqlplus -s -l scott/book @m12.txt 2e3 ${1}128=150 {} 128 >/dev/null;zzdate sleep 5 zzdate;seq 150 | xargs -I{} -P 150 sqlplus -s -l scott/book @m12.txt 2e3 ${1}001=150 {} 1 >/dev/null;zzdate --//$ echo {a..z} | xargs -IQ bash -c ./ee2.sh Q $ . ee2.sh a >> ee2.txt $ . ee2.sh b >> ee2.txt $ . ee2.sh c >> ee2.txt $ . ee2.sh d >> ee2.txt --//保存为ee2.txt $ cat ee2.txt trunc(sysdate)+09/24+14/1440+13/86400 == 2021/08/27 09:14:13 trunc(sysdate)+09/24+14/1440+15/86400 == 2021/08/27 09:14:15 trunc(sysdate)+09/24+14/1440+20/86400 == 2021/08/27 09:14:20 trunc(sysdate)+09/24+15/1440+34/86400 == 2021/08/27 09:15:34 trunc(sysdate)+09/24+16/1440+40/86400 == 2021/08/27 09:16:40 trunc(sysdate)+09/24+16/1440+42/86400 == 2021/08/27 09:16:42 trunc(sysdate)+09/24+16/1440+47/86400 == 2021/08/27 09:16:47 trunc(sysdate)+09/24+18/1440+01/86400 == 2021/08/27 09:18:01 trunc(sysdate)+09/24+19/1440+01/86400 == 2021/08/27 09:19:01 trunc(sysdate)+09/24+19/1440+04/86400 == 2021/08/27 09:19:04 trunc(sysdate)+09/24+19/1440+09/86400 == 2021/08/27 09:19:09 trunc(sysdate)+09/24+20/1440+22/86400 == 2021/08/27 09:20:22 trunc(sysdate)+09/24+21/1440+46/86400 == 2021/08/27 09:21:46 trunc(sysdate)+09/24+21/1440+48/86400 == 2021/08/27 09:21:48 trunc(sysdate)+09/24+21/1440+53/86400 == 2021/08/27 09:21:53 trunc(sysdate)+09/24+23/1440+07/86400 == 2021/08/27 09:23:07 $ tac ee2.txt | awk '{print "("$1")"}' | paste -d"-" - - | awk '{print "set head off\nselect (",$1,")*86400 cc from dual;"}' | sqlplus -s -l scott/book | tac 2 74 2 74 3 73 2 74 --//说明：我使用tac倒看,然后两个时间相减，然后在使用tac倒回来，这样前面显示的对应child_number最大的执行时间在前,可以发现 --//child_number越小执行时间越长. SCOTT@book> Select method,count(*),round(avg(TIME_ELA),0),sum(TIME_ELA) from scott.job_times group by method order by 3 ; METHOD COUNT(*) ROUND(AVG(TIME_ELA),0) SUM(TIME_ELA) -------------------- ---------- ---------------------- ------------- c128=150 150 66 9949 a128=150 150 75 11254 d128=150 150 77 11491 c001=150 150 7097 1064531 a001=150 150 7112 1066750 b001=150 150 7129 1069343 d001=150 150 7131 1069665 b128=150 150 14246322 2136948289 8 rows selected. --//遇到一个奇怪的问题,METHOD='b128=150'的结果有点奇怪.这个可能是dbms_utility.get_time的问题.参考链接: --//http://blog.itpub.net/267265/viewspace-2146955/ =>[20171106]DBMS_UTILITY.GET_TIME().txt SCOTT@book> select * from scott.job_times where method='b128=150' and time_ela>=1000; SID TIME_ELA METHOD ---- ----------- -------------------- 34 2136937178 b128=150 --//我检查sid = 34已经不存在了。 SCOTT@book> select dbms_utility.get_time() from dual ; DBMS_UTILITY.GET_TIME() ----------------------- 2137038644 --//2^31 = 2147483648 --//(2137038644-2136937178)/100 = 1014.66 秒,1014.66/60 = 16.911分钟,难道测试时回话被kill了吗？ --//不应该是dbms_utility.get_time的问题。不理解先放弃这个问题探究.排除例外看看。 SCOTT@book> Select method,count(*),round(avg(TIME_ELA),0),sum(TIME_ELA) from scott.job_times where TIME_ELA<=10000 group by method order by 3 ; METHOD COUNT(*) ROUND(AVG(TIME_ELA),0) SUM(TIME_ELA) -------------------- ---------- ---------------------- ------------- c128=150 150 66 9949 b128=150 149 75 11111 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ a128=150 150 75 11254 d128=150 150 77 11491 c001=150 150 7097 1064531 a001=150 150 7112 1066750 b001=150 150 7129 1069343 d001=150 150 7131 1069665 8 rows selected. --//等上一段时间....看看子光标消失。 SCOTT@book> select count(*) from v$sql where sql_id='5zfc9hksnyp90'; COUNT(*) ---------- 34 $ . ee2.sh e >> ee2.txt SCOTT@book> select count(*) from v$sql where sql_id='5zfc9hksnyp90'; COUNT(*) ---------- 4 SCOTT@book> select child_number,executions from v$sql where sql_id='5zfc9hksnyp90' ; CHILD_NUMBER EXECUTIONS ------------ ---------- 0 1681806 125 6 126 6 127 1767268 --//第2次执行时检查发现仅仅剩下4个子光标. $ . ee2.sh f >> ee2.txt $ tac ee2.txt | awk '{print "("$1")"}' | paste -d"-" - - | awk '{print "set head off\nselect (",$1,")*86400 cc from dual;"}' | sqlplus -s -l scott/book | tac 2 74 2 74 3 73 2 74 3 75 2 76 --//可以看出中间的子光标消失,并没有改善执行的效率. SCOTT@book> Select method,count(*),round(avg(TIME_ELA),0),sum(TIME_ELA) from scott.job_times where TIME_ELA<=10000 group by method order by 3 ; METHOD COUNT(*) ROUND(AVG(TIME_ELA),0) SUM(TIME_ELA) --------- -------- ---------------------- ------------- c128=150 150 66 9949 f128=150 150 71 10652 a128=150 150 75 11254 b128=150 149 75 11111 d128=150 150 77 11491 e128=150 150 82 12363 c001=150 150 7097 1064531 a001=150 150 7112 1066750 b001=150 150 7129 1069343 d001=150 150 7131 1069665 f001=150 150 7266 1089951 e001=150 150 7307 1096089 12 rows selected. 4.做一个library_cache转储看看: SCOTT@book> select child_number,executions from v$sql where sql_id='5zfc9hksnyp90' ; CHILD_NUMBER EXECUTIONS ------------ ---------- 0 1799562 125 6 126 6 127 1767268 SYS@book> @ sharepool/shp4 5zfc9hksnyp90 0 TEXT KGLHDADR KGLHDPAR C40 KGLHDLMD KGLHDPMD KGLHDIVC KGLOBHD0 KGLOBHD6 KGLOBHS0 KGLOBHS6 KGLOBT16 N0_6_16 N20 KGLNAHSH KGLOBT03 KGLOBT09 --------------------- ---------------- ---------------- ---------------------------------------- ---------- ---------- ---------- ---------------- ---------------- ---------- ---------- ---------- --------- ---------- ---------- ------------- ---------- child handle address 000000007C39CE50 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 000000007C39CD98 000000007C39D920 4528 12144 160045 176717 176717 2974766368 5zfc9hksnyp90 0 child handle address 000000007C333078 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 1 child handle address 000000007C3250E0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 2 child handle address 000000007C319148 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 3 child handle address 000000007C30D1B0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 4 child handle address 000000007C2FF218 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 5 child handle address 000000007C2F3280 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 6 child handle address 000000007C2E72E8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 7 child handle address 000000007C2D9350 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 8 child handle address 000000007C2CD3B8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 9 child handle address 000000007C2C1420 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 10 child handle address 000000007C2B3488 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 11 child handle address 000000007C2A74F0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 12 child handle address 000000007C29A4B8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 13 child handle address 000000007C28C520 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 14 child handle address 000000007C280588 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 15 child handle address 000000007C2745F0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 16 child handle address 000000007C266658 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 17 child handle address 000000007C25A6C0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 18 child handle address 000000007C24E728 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 19 child handle address 000000007C240790 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 20 child handle address 000000007C2347F8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 21 child handle address 000000007C228860 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 22 child handle address 000000007C21A8C8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 23 child handle address 000000007C20E820 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 24 child handle address 000000007C202978 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 25 child handle address 000000007C1F49E0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 26 child handle address 000000007C1E79A8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 27 child handle address 000000007C1DBA10 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 28 child handle address 000000007C1CDA78 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 29 child handle address 000000007C1C1AE0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 30 child handle address 000000007C1B5B48 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 31 child handle address 000000007C1A7BB0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 32 child handle address 000000007C19BC18 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 33 child handle address 000000007C18FC80 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 34 child handle address 000000007C181CE8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 35 child handle address 000000007C175D50 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 36 child handle address 000000007C169DB8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 37 child handle address 000000007C15BE20 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 38 child handle address 000000007C14FE88 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 39 child handle address 000000007C142E50 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 40 child handle address 000000007C134EB8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 41 child handle address 000000007C128F20 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 42 child handle address 000000007C11CF88 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 43 child handle address 000000007C10EFF0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 44 child handle address 000000007C103058 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 45 child handle address 000000007C0F70C0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 46 child handle address 000000007C0E9128 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 47 child handle address 000000007C0DD190 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 48 child handle address 000000007C0D11F8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 49 child handle address 000000007C0C3260 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 50 child handle address 000000007C0B72C8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 51 child handle address 000000007C0AB330 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 52 child handle address 000000007C09D398 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 53 child handle address 000000007C091400 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 54 child handle address 000000007C085468 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 55 child handle address 000000007C0774D0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 56 child handle address 000000007C06B538 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 57 child handle address 000000007C05F5A0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 58 child handle address 000000007C051608 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 59 child handle address 000000007C045670 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 60 child handle address 000000007C03E7D8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 61 child handle address 000000007BFEDAC0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 62 child handle address 000000007BFE1B28 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 63 child handle address 000000007BFD5B90 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 64 child handle address 000000007BFC7BF8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 65 child handle address 000000007BFBBC60 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 66 child handle address 000000007BFAFCC8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 67 child handle address 000000007BFA1D30 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 68 child handle address 000000007BF95D98 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 69 child handle address 000000007BF89E00 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 70 child handle address 000000007BF7BE68 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 71 child handle address 000000007BF6FED0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 72 child handle address 000000007BF63F38 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 73 child handle address 000000007BF55FA0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 74 child handle address 000000007BF4A008 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 75 child handle address 000000007BF3E070 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 76 child handle address 000000007BF300D8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 77 child handle address 000000007BF24140 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 78 child handle address 000000007BF181A8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 79 child handle address 000000007BF0A210 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 80 child handle address 000000007BEFE278 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 81 child handle address 000000007BEF1240 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 82 child handle address 000000007BEE32A8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 83 child handle address 000000007BED7310 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 84 child handle address 000000007BECB378 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 85 child handle address 000000007BEBD3E0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 86 child handle address 000000007BEB1448 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 87 child handle address 000000007BEA54B0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 88 child handle address 000000007BE97518 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 89 child handle address 000000007BE8B580 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 90 child handle address 000000007BE7F5E8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 91 child handle address 000000007BE71650 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 92 child handle address 000000007BE656B8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 93 child handle address 000000007BE59720 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 94 child handle address 000000007BE4B788 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 95 child handle address 000000007BE3E750 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 96 child handle address 000000007BE327B8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 97 child handle address 000000007BE24820 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 98 child handle address 000000007BE18888 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 99 child handle address 000000007BE0C8F0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 100 child handle address 000000007BDFE958 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 101 child handle address 000000007BDF29C0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 102 child handle address 000000007BDE6A28 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 103 child handle address 000000007BDD8A90 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 104 child handle address 000000007BDCCAF8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 105 child handle address 000000007BDC0B60 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 106 child handle address 000000007BDB2BC8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 107 child handle address 000000007BDA6C30 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 108 child handle address 000000007BD9AC98 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 109 child handle address 000000007BD8CD00 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 110 child handle address 000000007BD80D68 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 111 child handle address 000000007BD74DD0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 112 child handle address 000000007BD66E38 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 113 child handle address 000000007BD5AEA0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 114 child handle address 000000007BD4EF08 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 115 child handle address 000000007BD40F70 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 116 child handle address 000000007BD34FD8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 117 child handle address 000000007BD29040 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 118 child handle address 000000007BD1B0A8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 119 child handle address 000000007BD0F110 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 120 child handle address 000000007BD03178 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 121 child handle address 000000007BCF51E0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 122 child handle address 000000007BCE9248 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 123 child handle address 000000007BCDD2B0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 00 00 0 0 160045 160045 160045 2974766368 5zfc9hksnyp90 124 child handle address 000000007BCCF318 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 000000007BCCF260 00 4528 0 160045 164573 164573 2974766368 5zfc9hksnyp90 125 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ child handle address 000000007BCC3380 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 000000007BCC32C8 000000007BCCFC98 4528 12144 160045 176717 176717 2974766368 5zfc9hksnyp90 126 child handle address 000000007BCB73E8 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 000000007BCB7330 000000007BCD0158 4528 12144 160045 176717 176717 2974766368 5zfc9hksnyp90 127 parent handle address 000000007C39E2D0 000000007C39E2D0 SELECT COUNT(NAME) FROM T WHERE ID=1 0 0 0 000000007C39E218 00 163528 0 0 163528 163528 2974766368 5zfc9hksnyp90 65535 129 rows selected. --//从显示看v$sql查询不到，主要问题是对应KGLOBHD0，KGLOBHD6消失了。 --//有点意外的是CHILD_NUMBER=126,KGLOBHD0=000000007BCCF260 ,KGLOBHD6=00. SCOTT@book> select child_number,executions from v$sql where sql_id='5zfc9hksnyp90' ; CHILD_NUMBER EXECUTIONS ------------ ---------- 0 1799562 125 6 126 6 127 1767268 --//v$sql视图能看到。 SYS@book> oradebug setmypid Statement processed. SYS@book> oradebug dump library_cache 10; Statement processed. SYS@book> oradebug tracefile_name /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_64920.trc Bucket: #=87328 Mutex=0x80493530(0, 257, 0, 6) LibraryHandle: Address=0x7e3afbb8 Hash=3795520 LockMode=0 PinMode=0 LoadLockMode=0 Status=0 ObjectName: Name=APEX_030200.WWV_FLOW_WEB_SERVICES FullHashValue=d3db6ab290541f75d2d41ef703795520 Namespace=TABLE/PROCEDURE(01) Type=PACKAGE(09) Identifier=85471 OwnerIdn=77 Statistics: InvalidationCount=0 ExecutionCount=0 LoadCount=0 ActiveLocks=0 TotalLockCount=0 TotalPinCount=0 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0x7e3afc68(0, 1, 0, 0) Mutex=0x7e3afcf8(64, 39, 0, 6) Flags=PIN/TIM/[00000800] WaitersLists: Lock=0x7e3afc48[0x7e3afc48,0x7e3afc48] Pin=0x7e3afc28[0x7e3afc28,0x7e3afc28] LoadLock=0x7e3afca0[0x7e3afca0,0x7e3afca0] Timestamp: Current=08-24-2013 11:58:42 HandleReference: Address=0x7e3afd80 Handle=(nil) Flags=[00] ReferenceList: Reference: Address=0x7e37b870 Handle=0x7cd12c30 Flags=DEP[01] Timestamp=08-24-2013 11:58:42 InvalidatedFrom=0 LibraryHandle: Address=0x7c39e2d0 Hash=b14f5520 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD ObjectName: Name=SELECT COUNT(NAME) FROM T WHERE ID=1 FullHashValue=c11a46b81ff591945fb98984b14f5520 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=2974766368 OwnerIdn=83 Statistics: InvalidationCount=0 ExecutionCount=3281106 LoadCount=129 ActiveLocks=0 TotalLockCount=3600768 TotalPinCount=1 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=4 Version=0 BucketInUse=129 HandleInUse=129 HandleReferenceCount=0 Concurrency: DependencyMutex=0x7c39e380(0, 443, 0, 0) Mutex=0x7c39e410(64, 14415658, 609615, 6) Flags=RON/PIN/TIM/PN0/DBN/[10012841] WaitersLists: Lock=0x7c39e360[0x7c39e360,0x7c39e360] Pin=0x7c39e340[0x7c39e340,0x7c39e340] LoadLock=0x7c39e3b8[0x7c39e3b8,0x7c39e3b8] Timestamp: Current=08-27-2021 09:11:49 HandleReference: Address=0x7c39e4a0 Handle=(nil) Flags=[00] ReferenceList: Reference: Address=0x7cd33bf0 Handle=0x7e2aaa00 Flags=ROD[21] Reference: Address=0x7cebf8c0 Handle=0x7d0958a8 Flags=ROD[21] Reference: Address=0x7bcb5398 Handle=0x7bcb60f8 Flags=ROD[21] Reference: Address=0x7bcbbf08 Handle=0x7bcee960 Flags=ROD[21] Reference: Address=0x7bcc1330 Handle=0x7bcc2090 Flags=ROD[21] Reference: Address=0x7bcc7ea0 Handle=0x7bcfb8f8 Flags=ROD[21] Reference: Address=0x7bccd2c8 Handle=0x7bcce028 Flags=ROD[21] Reference: Address=0x7bcdb260 Handle=0x7bcdbfc0 Flags=ROD[21] Reference: Address=0x7bce71f8 Handle=0x7bce7f58 Flags=ROD[21] Reference: Address=0x7bcf3190 Handle=0x7bcf3ef0 Flags=ROD[21] Reference: Address=0x7bd01128 Handle=0x7bd01e88 Flags=ROD[21] Reference: Address=0x7bd0d0c0 Handle=0x7bd0de20 Flags=ROD[21] Reference: Address=0x7bd19058 Handle=0x7bd19db8 Flags=ROD[21] Reference: Address=0x7bd26ff0 Handle=0x7bd27d50 Flags=ROD[21] Reference: Address=0x7bd32f88 Handle=0x7bd33ce8 Flags=ROD[21] Reference: Address=0x7bd3ef20 Handle=0x7bd3fc80 Flags=ROD[21] Reference: Address=0x7bd4ceb8 Handle=0x7bd4dc18 Flags=ROD[21] Reference: Address=0x7bd58e50 Handle=0x7bd59bb0 Flags=ROD[21] Reference: Address=0x7bd64de8 Handle=0x7bd65b48 Flags=ROD[21] Reference: Address=0x7bd72d80 Handle=0x7bd73ae0 Flags=ROD[21] Reference: Address=0x7bd7ed18 Handle=0x7bd7fa78 Flags=ROD[21] Reference: Address=0x7bd8acb0 Handle=0x7bd8ba10 Flags=ROD[21] Reference: Address=0x7bd98c48 Handle=0x7bd999a8 Flags=ROD[21] Reference: Address=0x7bda4be0 Handle=0x7bda5940 Flags=ROD[21] Reference: Address=0x7bdb0b78 Handle=0x7bdb18d8 Flags=ROD[21] Reference: Address=0x7bdbeb10 Handle=0x7bdbf870 Flags=ROD[21] Reference: Address=0x7bdcaaa8 Handle=0x7bdcb808 Flags=ROD[21] Reference: Address=0x7bdd6a40 Handle=0x7bdd77a0 Flags=ROD[21] Reference: Address=0x7bde49d8 Handle=0x7bde5738 Flags=ROD[21] Reference: Address=0x7bdf0970 Handle=0x7bdf16d0 Flags=ROD[21] Reference: Address=0x7bdfc908 Handle=0x7bdfd668 Flags=ROD[21] Reference: Address=0x7be0a8a0 Handle=0x7be0b600 Flags=ROD[21] Reference: Address=0x7be16838 Handle=0x7be17598 Flags=ROD[21] Reference: Address=0x7be227d0 Handle=0x7be23530 Flags=ROD[21] Reference: Address=0x7be30768 Handle=0x7be314c8 Flags=ROD[21] Reference: Address=0x7be3c700 Handle=0x7be3d460 Flags=ROD[21] Reference: Address=0x7be49738 Handle=0x7be4a498 Flags=ROD[21] Reference: Address=0x7be576d0 Handle=0x7be58430 Flags=ROD[21] Reference: Address=0x7be63668 Handle=0x7be643c8 Flags=ROD[21] Reference: Address=0x7be6f600 Handle=0x7be70360 Flags=ROD[21] Reference: Address=0x7be7d598 Handle=0x7be7e2f8 Flags=ROD[21] Reference: Address=0x7be89530 Handle=0x7be8a290 Flags=ROD[21] Reference: Address=0x7be954c8 Handle=0x7be96228 Flags=ROD[21] Reference: Address=0x7bea3460 Handle=0x7bea41c0 Flags=ROD[21] Reference: Address=0x7beaf3f8 Handle=0x7beb0158 Flags=ROD[21] Reference: Address=0x7bebb390 Handle=0x7bebc0f0 Flags=ROD[21] Reference: Address=0x7bec9328 Handle=0x7beca088 Flags=ROD[21] Reference: Address=0x7bed52c0 Handle=0x7bed6020 Flags=ROD[21] Reference: Address=0x7bee1258 Handle=0x7bee1fb8 Flags=ROD[21] Reference: Address=0x7beef1f0 Handle=0x7beeff50 Flags=ROD[21] Reference: Address=0x7befc228 Handle=0x7befcf88 Flags=ROD[21] Reference: Address=0x7bf081c0 Handle=0x7bf08f20 Flags=ROD[21] Reference: Address=0x7bf16158 Handle=0x7bf16eb8 Flags=ROD[21] Reference: Address=0x7bf220f0 Handle=0x7bf22e50 Flags=ROD[21] Reference: Address=0x7bf2e088 Handle=0x7bf2ede8 Flags=ROD[21] Reference: Address=0x7bf3c020 Handle=0x7bf3cd80 Flags=ROD[21] Reference: Address=0x7bf47fb8 Handle=0x7bf48d18 Flags=ROD[21] Reference: Address=0x7bf53f50 Handle=0x7bf54cb0 Flags=ROD[21] Reference: Address=0x7bf61ee8 Handle=0x7bf62c48 Flags=ROD[21] Reference: Address=0x7bf6de80 Handle=0x7bf6ebe0 Flags=ROD[21] Reference: Address=0x7bf79e18 Handle=0x7bf7ab78 Flags=ROD[21] Reference: Address=0x7bf87db0 Handle=0x7bf88b10 Flags=ROD[21] Reference: Address=0x7bf93d48 Handle=0x7bf94aa8 Flags=ROD[21] Reference: Address=0x7bf9fce0 Handle=0x7bfa0a40 Flags=ROD[21] Reference: Address=0x7bfadc78 Handle=0x7bfae9d8 Flags=ROD[21] Reference: Address=0x7bfb9c10 Handle=0x7bfba970 Flags=ROD[21] Reference: Address=0x7bfc5ba8 Handle=0x7bfc6908 Flags=ROD[21] Reference: Address=0x7bfd3b40 Handle=0x7bfd48a0 Flags=ROD[21] Reference: Address=0x7bfdfad8 Handle=0x7bfe0838 Flags=ROD[21] Reference: Address=0x7bfeba70 Handle=0x7bfec7d0 Flags=ROD[21] Reference: Address=0x7bff92c0 Handle=0x7c03e4e8 Flags=ROD[21] Reference: Address=0x7c043620 Handle=0x7c044380 Flags=ROD[21] Reference: Address=0x7c04f5b8 Handle=0x7c050318 Flags=ROD[21] Reference: Address=0x7c39ae00 Handle=0x7c39bb60 Flags=ROD[21] LibraryObject: Address=0x7c39d260 HeapMask=0000-0001-0001-0000 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000] DataBlocks: Block: #='0' name=KGLH0^b14f5520 pins=0 Change=NONE Heap=0x7c39e218 Pointer=0x7c39d300 Extent=0x7c39d1e0 Flags=I/-/P/A/-/- FreedLocation=0 Alloc=155.734375 Size=159.062500 LoadTime=21369079260 ChildTable: size='128' Child: id='0' Table=0x7c39e110 Reference=0x7c39db50 Handle=0x7c39ce50 Child: id='1' Table=0x7c39e110 Reference=0x7c39e048 Handle=0x7c333078 Child: id='2' Table=0x7c39e110 Reference=0x7c325700 Handle=0x7c3250e0 Child: id='3' Table=0x7c39e110 Reference=0x7c325bc0 Handle=0x7c319148 Child: id='4' Table=0x7c39e110 Reference=0x7c326080 Handle=0x7c30d1b0 Child: id='5' Table=0x7c39e110 Reference=0x7c2ff838 Handle=0x7c2ff218 Child: id='6' Table=0x7c39e110 Reference=0x7c2ffcf8 Handle=0x7c2f3280 Child: id='7' Table=0x7c39e110 Reference=0x7c3001b8 Handle=0x7c2e72e8 Child: id='8' Table=0x7c39e110 Reference=0x7c2d9970 Handle=0x7c2d9350 Child: id='9' Table=0x7c39e110 Reference=0x7c2d9e30 Handle=0x7c2cd3b8 Child: id='10' Table=0x7c39e110 Reference=0x7c2da2f0 Handle=0x7c2c1420 Child: id='11' Table=0x7c39e110 Reference=0x7c2b3aa8 Handle=0x7c2b3488 Child: id='12' Table=0x7c39e110 Reference=0x7c2b3f68 Handle=0x7c2a74f0 Child: id='13' Table=0x7c39e110 Reference=0x7c2b4428 Handle=0x7c29a4b8 Child: id='14' Table=0x7c39e110 Reference=0x7c28cb40 Handle=0x7c28c520 Child: id='15' Table=0x7c39e110 Reference=0x7c28d000 Handle=0x7c280588 Child: id='16' Table=0x7c2b44e8 Reference=0x7c28d4c0 Handle=0x7c2745f0 Child: id='17' Table=0x7c2b44e8 Reference=0x7c266c78 Handle=0x7c266658 Child: id='18' Table=0x7c2b44e8 Reference=0x7c267138 Handle=0x7c25a6c0 Child: id='19' Table=0x7c2b44e8 Reference=0x7c2675f8 Handle=0x7c24e728 Child: id='20' Table=0x7c2b44e8 Reference=0x7c240db0 Handle=0x7c240790 Child: id='21' Table=0x7c2b44e8 Reference=0x7c241270 Handle=0x7c2347f8 Child: id='22' Table=0x7c2b44e8 Reference=0x7c241730 Handle=0x7c228860 Child: id='23' Table=0x7c2b44e8 Reference=0x7c21aee8 Handle=0x7c21a8c8 Child: id='24' Table=0x7c2b44e8 Reference=0x7c21b3a8 Handle=0x7c20e820 Child: id='25' Table=0x7c2b44e8 Reference=0x7c21b868 Handle=0x7c202978 Child: id='26' Table=0x7c2b44e8 Reference=0x7c1f5000 Handle=0x7c1f49e0 Child: id='27' Table=0x7c2b44e8 Reference=0x7c1f54c0 Handle=0x7c1e79a8 Child: id='28' Table=0x7c2b44e8 Reference=0x7c1f5980 Handle=0x7c1dba10 Child: id='29' Table=0x7c2b44e8 Reference=0x7c1ce098 Handle=0x7c1cda78 Child: id='30' Table=0x7c2b44e8 Reference=0x7c1ce558 Handle=0x7c1c1ae0 Child: id='31' Table=0x7c2b44e8 Reference=0x7c1cea18 Handle=0x7c1b5b48 Child: id='32' Table=0x7c1ceb18 Reference=0x7c1a81d0 Handle=0x7c1a7bb0 Child: id='33' Table=0x7c1ceb18 Reference=0x7c1a8690 Handle=0x7c19bc18 Child: id='34' Table=0x7c1ceb18 Reference=0x7c1a8b50 Handle=0x7c18fc80 Child: id='35' Table=0x7c1ceb18 Reference=0x7c182308 Handle=0x7c181ce8 Child: id='36' Table=0x7c1ceb18 Reference=0x7c1827c8 Handle=0x7c175d50 Child: id='37' Table=0x7c1ceb18 Reference=0x7c182c88 Handle=0x7c169db8 Child: id='38' Table=0x7c1ceb18 Reference=0x7c15c440 Handle=0x7c15be20 Child: id='39' Table=0x7c1ceb18 Reference=0x7c15c900 Handle=0x7c14fe88 Child: id='40' Table=0x7c1ceb18 Reference=0x7c15cdc0 Handle=0x7c142e50 Child: id='41' Table=0x7c1ceb18 Reference=0x7c1354d8 Handle=0x7c134eb8 Child: id='42' Table=0x7c1ceb18 Reference=0x7c135998 Handle=0x7c128f20 Child: id='43' Table=0x7c1ceb18 Reference=0x7c135e58 Handle=0x7c11cf88 Child: id='44' Table=0x7c1ceb18 Reference=0x7c10f610 Handle=0x7c10eff0 Child: id='45' Table=0x7c1ceb18 Reference=0x7c10fad0 Handle=0x7c103058 Child: id='46' Table=0x7c1ceb18 Reference=0x7c10ff90 Handle=0x7c0f70c0 Child: id='47' Table=0x7c1ceb18 Reference=0x7c0e9748 Handle=0x7c0e9128 Child: id='48' Table=0x7c110070 Reference=0x7c0e9c08 Handle=0x7c0dd190 Child: id='49' Table=0x7c110070 Reference=0x7c0ea0c8 Handle=0x7c0d11f8 Child: id='50' Table=0x7c110070 Reference=0x7c0c3880 Handle=0x7c0c3260 Child: id='51' Table=0x7c110070 Reference=0x7c0c3d40 Handle=0x7c0b72c8 Child: id='52' Table=0x7c110070 Reference=0x7c0c4200 Handle=0x7c0ab330 Child: id='53' Table=0x7c110070 Reference=0x7c09d9b8 Handle=0x7c09d398 Child: id='54' Table=0x7c110070 Reference=0x7c09de78 Handle=0x7c091400 Child: id='55' Table=0x7c110070 Reference=0x7c09e338 Handle=0x7c085468 Child: id='56' Table=0x7c110070 Reference=0x7c077af0 Handle=0x7c0774d0 Child: id='57' Table=0x7c110070 Reference=0x7c077fb0 Handle=0x7c06b538 Child: id='58' Table=0x7c110070 Reference=0x7c078470 Handle=0x7c05f5a0 Child: id='59' Table=0x7c110070 Reference=0x7c051c28 Handle=0x7c051608 Child: id='60' Table=0x7c110070 Reference=0x7c0520e8 Handle=0x7c045670 Child: id='61' Table=0x7c110070 Reference=0x7c0525a8 Handle=0x7c03e7d8 Child: id='62' Table=0x7c110070 Reference=0x7bfee0e0 Handle=0x7bfedac0 Child: id='63' Table=0x7c110070 Reference=0x7bfee5a0 Handle=0x7bfe1b28 Child: id='64' Table=0x7c052668 Reference=0x7bfeeaa0 Handle=0x7bfd5b90 Child: id='65' Table=0x7c052668 Reference=0x7bfc8218 Handle=0x7bfc7bf8 Child: id='66' Table=0x7c052668 Reference=0x7bfc86d8 Handle=0x7bfbbc60 Child: id='67' Table=0x7c052668 Reference=0x7bfc8b98 Handle=0x7bfafcc8 Child: id='68' Table=0x7c052668 Reference=0x7bfa2350 Handle=0x7bfa1d30 Child: id='69' Table=0x7c052668 Reference=0x7bfa2810 Handle=0x7bf95d98 Child: id='70' Table=0x7c052668 Reference=0x7bfa2cd0 Handle=0x7bf89e00 Child: id='71' Table=0x7c052668 Reference=0x7bf7c488 Handle=0x7bf7be68 Child: id='72' Table=0x7c052668 Reference=0x7bf7c948 Handle=0x7bf6fed0 Child: id='73' Table=0x7c052668 Reference=0x7bf7ce08 Handle=0x7bf63f38 Child: id='74' Table=0x7c052668 Reference=0x7bf565c0 Handle=0x7bf55fa0 Child: id='75' Table=0x7c052668 Reference=0x7bf56a80 Handle=0x7bf4a008 Child: id='76' Table=0x7c052668 Reference=0x7bf56f40 Handle=0x7bf3e070 Child: id='77' Table=0x7c052668 Reference=0x7bf306f8 Handle=0x7bf300d8 Child: id='78' Table=0x7c052668 Reference=0x7bf30bb8 Handle=0x7bf24140 Child: id='79' Table=0x7c052668 Reference=0x7bf31078 Handle=0x7bf181a8 Child: id='80' Table=0x7bf31178 Reference=0x7bf0a830 Handle=0x7bf0a210 Child: id='81' Table=0x7bf31178 Reference=0x7bf0acf0 Handle=0x7befe278 Child: id='82' Table=0x7bf31178 Reference=0x7bf0b1b0 Handle=0x7bef1240 Child: id='83' Table=0x7bf31178 Reference=0x7bee38c8 Handle=0x7bee32a8 Child: id='84' Table=0x7bf31178 Reference=0x7bee3d88 Handle=0x7bed7310 Child: id='85' Table=0x7bf31178 Reference=0x7bee4248 Handle=0x7becb378 Child: id='86' Table=0x7bf31178 Reference=0x7bebda00 Handle=0x7bebd3e0 Child: id='87' Table=0x7bf31178 Reference=0x7bebdec0 Handle=0x7beb1448 Child: id='88' Table=0x7bf31178 Reference=0x7bebe380 Handle=0x7bea54b0 Child: id='89' Table=0x7bf31178 Reference=0x7be97b38 Handle=0x7be97518 Child: id='90' Table=0x7bf31178 Reference=0x7be97ff8 Handle=0x7be8b580 Child: id='91' Table=0x7bf31178 Reference=0x7be984b8 Handle=0x7be7f5e8 Child: id='92' Table=0x7bf31178 Reference=0x7be71c70 Handle=0x7be71650 Child: id='93' Table=0x7bf31178 Reference=0x7be72130 Handle=0x7be656b8 Child: id='94' Table=0x7bf31178 Reference=0x7be725f0 Handle=0x7be59720 Child: id='95' Table=0x7bf31178 Reference=0x7be4bda8 Handle=0x7be4b788 Child: id='96' Table=0x7be726d0 Reference=0x7be4c268 Handle=0x7be3e750 Child: id='97' Table=0x7be726d0 Reference=0x7be4c728 Handle=0x7be327b8 Child: id='98' Table=0x7be726d0 Reference=0x7be24e40 Handle=0x7be24820 Child: id='99' Table=0x7be726d0 Reference=0x7be25300 Handle=0x7be18888 Child: id='100' Table=0x7be726d0 Reference=0x7be257c0 Handle=0x7be0c8f0 Child: id='101' Table=0x7be726d0 Reference=0x7bdfef78 Handle=0x7bdfe958 Child: id='102' Table=0x7be726d0 Reference=0x7bdff438 Handle=0x7bdf29c0 Child: id='103' Table=0x7be726d0 Reference=0x7bdff8f8 Handle=0x7bde6a28 Child: id='104' Table=0x7be726d0 Reference=0x7bdd90b0 Handle=0x7bdd8a90 Child: id='105' Table=0x7be726d0 Reference=0x7bdd9570 Handle=0x7bdccaf8 Child: id='106' Table=0x7be726d0 Reference=0x7bdd9a30 Handle=0x7bdc0b60 Child: id='107' Table=0x7be726d0 Reference=0x7bdb31e8 Handle=0x7bdb2bc8 Child: id='108' Table=0x7be726d0 Reference=0x7bdb36a8 Handle=0x7bda6c30 Child: id='109' Table=0x7be726d0 Reference=0x7bdb3b68 Handle=0x7bd9ac98 Child: id='110' Table=0x7be726d0 Reference=0x7bd8d320 Handle=0x7bd8cd00 Child: id='111' Table=0x7be726d0 Reference=0x7bd8d7e0 Handle=0x7bd80d68 Child: id='112' Table=0x7bdb3c28 Reference=0x7bd8dca0 Handle=0x7bd74dd0 Child: id='113' Table=0x7bdb3c28 Reference=0x7bd67458 Handle=0x7bd66e38 Child: id='114' Table=0x7bdb3c28 Reference=0x7bd67918 Handle=0x7bd5aea0 Child: id='115' Table=0x7bdb3c28 Reference=0x7bd67dd8 Handle=0x7bd4ef08 Child: id='116' Table=0x7bdb3c28 Reference=0x7bd41590 Handle=0x7bd40f70 Child: id='117' Table=0x7bdb3c28 Reference=0x7bd41a50 Handle=0x7bd34fd8 Child: id='118' Table=0x7bdb3c28 Reference=0x7bd41f10 Handle=0x7bd29040 Child: id='119' Table=0x7bdb3c28 Reference=0x7bd1b6c8 Handle=0x7bd1b0a8 Child: id='120' Table=0x7bdb3c28 Reference=0x7bd1bb88 Handle=0x7bd0f110 Child: id='121' Table=0x7bdb3c28 Reference=0x7bd1c048 Handle=0x7bd03178 Child: id='122' Table=0x7bdb3c28 Reference=0x7bcf5800 Handle=0x7bcf51e0 Child: id='123' Table=0x7bdb3c28 Reference=0x7bcf5cc0 Handle=0x7bce9248 Child: id='124' Table=0x7bdb3c28 Reference=0x7bcf6180 Handle=0x7bcdd2b0 Child: id='125' Table=0x7bdb3c28 Reference=0x7bccf938 Handle=0x7bccf318 Child: id='126' Table=0x7bdb3c28 Reference=0x7bccfdf8 Handle=0x7bcc3380 Child: id='127' Table=0x7bdb3c28 Reference=0x7bcd02b8 Handle=0x7bcb73e8 NamespaceDump: Parent Cursor: sql_id=5zfc9hksnyp90 parent=0x7c39d300 maxchild=128 plk=n ppn=n CursorDiagnosticsNodes: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=>我估计探察应该按照这个顺序.ChildNumber=127执行快就很好理解了。 ChildNode: ChildNumber=127 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 128 1 ChildNode: ChildNumber=126 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 127 128 ChildNode: ChildNumber=125 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 126 127 ChildNode: ChildNumber=124 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 125 126 ChildNode: ChildNumber=123 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 124 125 ChildNode: ChildNumber=122 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 123 124 ChildNode: ChildNumber=121 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 122 123 ChildNode: ChildNumber=120 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 121 122 ChildNode: ChildNumber=119 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 120 121 ChildNode: ChildNumber=118 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 119 120 ChildNode: ChildNumber=117 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 118 119 ChildNode: ChildNumber=116 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 117 118 ChildNode: ChildNumber=115 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 116 117 ChildNode: ChildNumber=114 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 115 116 ChildNode: ChildNumber=113 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 114 115 ChildNode: ChildNumber=112 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 113 114 ChildNode: ChildNumber=111 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 112 113 ChildNode: ChildNumber=110 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 111 112 ChildNode: ChildNumber=109 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 110 111 ChildNode: ChildNumber=108 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 109 110 ChildNode: ChildNumber=107 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 108 109 ChildNode: ChildNumber=106 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 107 108 ChildNode: ChildNumber=105 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 106 107 ChildNode: ChildNumber=104 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 105 106 ChildNode: ChildNumber=103 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 104 105 ChildNode: ChildNumber=102 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 103 104 ChildNode: ChildNumber=101 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 102 103 ChildNode: ChildNumber=100 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 101 102 ChildNode: ChildNumber=99 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 100 101 ChildNode: ChildNumber=98 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 99 100 ChildNode: ChildNumber=97 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 98 99 ChildNode: ChildNumber=96 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 97 98 ChildNode: ChildNumber=95 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 96 97 ChildNode: ChildNumber=94 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 95 96 ChildNode: ChildNumber=93 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 94 95 ChildNode: ChildNumber=92 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 93 94 ChildNode: ChildNumber=91 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 92 93 ChildNode: ChildNumber=90 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 91 92 ChildNode: ChildNumber=89 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 90 91 ChildNode: ChildNumber=88 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 89 90 ChildNode: ChildNumber=87 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 88 89 ChildNode: ChildNumber=86 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 87 88 ChildNode: ChildNumber=85 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 86 87 ChildNode: ChildNumber=84 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 85 86 ChildNode: ChildNumber=83 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 84 85 ChildNode: ChildNumber=82 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 83 84 ChildNode: ChildNumber=81 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 82 83 ChildNode: ChildNumber=80 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 81 82 ChildNode: ChildNumber=79 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 80 81 ChildNode: ChildNumber=78 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 79 80 ChildNode: ChildNumber=77 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 78 79 ChildNode: ChildNumber=76 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 77 78 ChildNode: ChildNumber=75 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 76 77 ChildNode: ChildNumber=74 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 75 76 ChildNode: ChildNumber=73 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 74 75 ChildNode: ChildNumber=72 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 73 74 ChildNode: ChildNumber=71 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 72 73 ChildNode: ChildNumber=70 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 71 72 ChildNode: ChildNumber=69 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 70 71 ChildNode: ChildNumber=68 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 69 70 ChildNode: ChildNumber=67 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 68 69 ChildNode: ChildNumber=66 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 67 68 ChildNode: ChildNumber=65 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 66 67 ChildNode: ChildNumber=64 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 65 66 ChildNode: ChildNumber=63 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 64 65 ChildNode: ChildNumber=62 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 63 64 ChildNode: ChildNumber=61 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 62 63 ChildNode: ChildNumber=60 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 61 62 ChildNode: ChildNumber=59 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 60 61 ChildNode: ChildNumber=58 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 59 60 ChildNode: ChildNumber=57 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 58 59 ChildNode: ChildNumber=56 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 57 58 ChildNode: ChildNumber=55 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 56 57 ChildNode: ChildNumber=54 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 55 56 ChildNode: ChildNumber=53 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 54 55 ChildNode: ChildNumber=52 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 53 54 ChildNode: ChildNumber=51 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 52 53 ChildNode: ChildNumber=50 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 51 52 ChildNode: ChildNumber=49 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 50 51 ChildNode: ChildNumber=48 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 49 50 ChildNode: ChildNumber=47 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 48 49 ChildNode: ChildNumber=46 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 47 48 ChildNode: ChildNumber=45 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 46 47 ChildNode: ChildNumber=44 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 45 46 ChildNode: ChildNumber=43 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 44 45 ChildNode: ChildNumber=42 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 43 44 ChildNode: ChildNumber=41 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 42 43 ChildNode: ChildNumber=40 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 41 42 ChildNode: ChildNumber=39 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 40 41 ChildNode: ChildNumber=38 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 39 40 ChildNode: ChildNumber=37 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 38 39 ChildNode: ChildNumber=36 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 37 38 ChildNode: ChildNumber=35 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 36 37 ChildNode: ChildNumber=34 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 35 36 ChildNode: ChildNumber=33 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 34 35 ChildNode: ChildNumber=32 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 33 34 ChildNode: ChildNumber=31 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 32 33 ChildNode: ChildNumber=30 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 31 32 ChildNode: ChildNumber=29 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 30 31 ChildNode: ChildNumber=28 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 29 30 ChildNode: ChildNumber=27 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 28 29 ChildNode: ChildNumber=26 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 27 28 ChildNode: ChildNumber=25 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 26 27 ChildNode: ChildNumber=24 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 25 26 ChildNode: ChildNumber=23 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 24 25 ChildNode: ChildNumber=22 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 23 24 ChildNode: ChildNumber=21 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 22 23 ChildNode: ChildNumber=20 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 21 22 ChildNode: ChildNumber=19 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 20 21 ChildNode: ChildNumber=18 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 19 20 ChildNode: ChildNumber=17 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 18 19 ChildNode: ChildNumber=16 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 17 18 ChildNode: ChildNumber=15 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 16 17 ChildNode: ChildNumber=14 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 15 16 ChildNode: ChildNumber=13 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 14 15 ChildNode: ChildNumber=12 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 13 14 ChildNode: ChildNumber=11 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 12 13 ChildNode: ChildNumber=10 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 11 12 ChildNode: ChildNumber=9 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 10 11 ChildNode: ChildNumber=8 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 9 10 ChildNode: ChildNumber=7 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 8 9 ChildNode: ChildNumber=6 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 7 8 ChildNode: ChildNumber=5 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 6 7 ChildNode: ChildNumber=4 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 5 6 ChildNode: ChildNumber=3 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 4 5 ChildNode: ChildNumber=2 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 3 4 ChildNode: ChildNumber=1 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 2 3 ChildNode: ChildNumber=0 ID=3 reason=Optimizer mismatch(12) size=2x228 optimizer_index_cost_adj= 1 2 5.总结： --//不小心又写的太长，不过可以发现子光标很多的情况下对性能的影响。 --//中间的子光标完全消失的情况没有测试到，有机会再看看。 6.体外话，我重新看了前面关于dbms_utility.get_time,感觉最大可能是回话kill了，或者挂起,另外写一篇文章说明。

编辑推荐：

返回列表

[20210818]测试sql语句子光标的性能4.txt

编辑推荐：

相关推荐

excel表格怎样在数字前输入0

excel表格里怎么替换数据

excel表格里面如何插入圆形

excel表格里怎么添加表格数据透视表

excel表格中怎么添加线边框

excel表格里怎样设置条件自动排序

excel表格例怎样导入数据库

Excel表格如何设置数据排序

excel表格里怎么选择性粘贴快捷键

excel表格怎么插入分隔符号

excel表格怎么设置多行多列数据内容排序

Excel表格如何设置行和列相互转换

excel表格连接公式怎么使用

excel表格怎样链接到cad中

雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效

制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用

最新软件资讯

热文推荐

天极热推