[20210818]測試sql語句子游標的效能4.txt
[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了，或者掛起,另外寫一篇文章說明。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-2789245/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20210812]測試sql語句子游標的效能.txtSQL
- [20210816]測試sql語句子游標的效能3.txtSQL
- [20210813]關於測試sql語句子游標的效能的一些補充說明.txtSQL
- [20160516]SQL共享游標的測試疑問.txtSQL
- [20160407]sql語句父子游標的堆轉儲.txtSQL
- Prepared SQL 效能測試SQL
- [20161228]sql語句父子游標的堆轉儲2.txtSQL
- Python的SQL效能測試PythonSQL
- Python 的 SQL 效能測試PythonSQL
- 使用profiler測試Oracle PL/SQL效能OracleSQL
- 效能測試學習(1)-效能測試分類與常見術語
- Android 滑鼠游標的圖形合成Android
- 控制input輸入框游標的位置
- Oracle DB 壓力測試相關效能指標及達到指標的方法Oracle指標
- 【效能測試】使用ab做Http效能測試HTTP
- 深入理解父遊標，子游標的概念
- 操作文字域內游標的jQuery程式碼jQuery
- 效能測試
- 效能測試：分散式測試分散式
- Jmeter介面測試+效能測試JMeter
- SQL Server 2005效能測試之CPU篇SQLServer
- 測試SQL Server各個版本的的效能 (轉)SQLServer
- 百萬資料查詢測試 只需1秒--Sql語句效率測試SQL
- Stax處理XML(一)——基於游標的查詢XML
- 微服務測試之效能測試微服務
- 效能測試之測試指標指標
- 測試開發之效能篇-效能測試設計
- Jmeter效能測試：高併發分散式效能測試JMeter分散式
- SQL Server 2008 效能測試和調優SQLServer
- 效能測試——效能測試-常見效能指標-總體概況指標
- Redis 效能測試Redis
- 效能測試流程
- xhprofphp效能測試PHP
- 效能測試工具
- Kafka效能測試Kafka
- 【效能測試】效能測試各知識第1篇：效能測試大綱【附程式碼文件】
- （一）效能測試（壓力測試、負載測試）負載
- 【PG效能測試】pgbench效能測試工具簡單使用