11.2 繫結變數執行計劃怎麼這樣？求助！
本來是想在11G下實驗一下http://www.itpub.net/thread-1323480-1-1.html
沒想到，發現了新的問題，新開帖求助
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期一 7月 12 15:14:21 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn test/test
已連線。
SQL> create table t (id varchar2(10),text varchar2(4000));
表已建立。
SQL> insert into t select '1',object_name from dba_objects;
已建立63859行。
SQL> insert into t values( '2','aaa');
已建立 1 行。
SQL> commit;
提交完成。
SQL> select id,count(*) from t group by id;
ID COUNT(*)
---------- ----------
1 63859
2 1
SQL> create index t_idx on t(id);
索引已建立。
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for all indexed co
lumns',cascade=>true);
PL/SQL 過程已成功完成。
SQL> var fid varchar2;
SQL> exec :fid := '2';
PL/SQL 過程已成功完成。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'));
SQL_ID fprdgayw5y5vq, child number 0
-------------------------------------
select * from t where id=:fid
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 97 (100)| |
|* 1 | TABLE ACCESS FULL| T | 31930 | 810K| 97 (2)| 00:00:02 |
--------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1 / T@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :FID (VARCHAR2(30), CSID=852): '2'
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("ID"=:FID)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "ID"[VARCHAR2,10], "T"."TEXT"[VARCHAR2,4000]
已選擇48行。
沒有設定_optim_peek_user_binds，並且，繫結變數也進行了bind peeking，為什麼還選擇全表掃描？
做一下10053
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
*** 2010-07-12 15:16:49.169
** Performing dynamic sampling initial checks. **
Column (#1):
NewDensity:0.500000, OldDensity:0.000008 BktCnt:5458, PopBktCnt:5458, PopValCnt:1, NDV:2
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
** Dynamic sampling initial checks returning FALSE.
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
去掉動態取樣試試
SQL> alter session set optimizer_dynamic_sampling=0;
會話已更改。
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
Column (#1):
NewDensity:0.500000, OldDensity:0.000008 BktCnt:5458, PopBktCnt:5458, PopValCnt:1, NDV:2
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 0)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
不是動態取樣的緣故，看看是否直方圖的問題？
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for all indexed co
lumns size 1',cascade=>true);
PL/SQL 過程已成功完成。
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 0)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
沒想到，發現了新的問題，新開帖求助
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期一 7月 12 15:14:21 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn test/test
已連線。
SQL> create table t (id varchar2(10),text varchar2(4000));
表已建立。
SQL> insert into t select '1',object_name from dba_objects;
已建立63859行。
SQL> insert into t values( '2','aaa');
已建立 1 行。
SQL> commit;
提交完成。
SQL> select id,count(*) from t group by id;
ID COUNT(*)
---------- ----------
1 63859
2 1
SQL> create index t_idx on t(id);
索引已建立。
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for all indexed co
lumns',cascade=>true);
PL/SQL 過程已成功完成。
SQL> var fid varchar2;
SQL> exec :fid := '2';
PL/SQL 過程已成功完成。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED'));
SQL_ID fprdgayw5y5vq, child number 0
-------------------------------------
select * from t where id=:fid
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 97 (100)| |
|* 1 | TABLE ACCESS FULL| T | 31930 | 810K| 97 (2)| 00:00:02 |
--------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1 / T@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :FID (VARCHAR2(30), CSID=852): '2'
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("ID"=:FID)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "ID"[VARCHAR2,10], "T"."TEXT"[VARCHAR2,4000]
已選擇48行。
沒有設定_optim_peek_user_binds，並且，繫結變數也進行了bind peeking，為什麼還選擇全表掃描？
做一下10053
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
*** 2010-07-12 15:16:49.169
** Performing dynamic sampling initial checks. **
Column (#1):
NewDensity:0.500000, OldDensity:0.000008 BktCnt:5458, PopBktCnt:5458, PopValCnt:1, NDV:2
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
** Dynamic sampling initial checks returning FALSE.
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
去掉動態取樣試試
SQL> alter session set optimizer_dynamic_sampling=0;
會話已更改。
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
Column (#1):
NewDensity:0.500000, OldDensity:0.000008 BktCnt:5458, PopBktCnt:5458, PopValCnt:1, NDV:2
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Using density: 0.500000 of col #1 as selectivity of unpopular value pred
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 0)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
不是動態取樣的緣故，看看是否直方圖的問題？
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for all indexed co
lumns size 1',cascade=>true);
PL/SQL 過程已成功完成。
SQL> alter system flush shared_pool;
系統已更改。
SQL> alter session set events '10053 trace name context forever';
會話已更改。
SQL> select * from t where id=:fid;
ID
----------
TEXT
--------------------------------------------------------------------------------
2
aaa
SQL> alter session set events '10053 trace name context off';
會話已更改。
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T Alias: T
#Rows: 63860 #Blks: 370 AvgRowLen: 26.00
Index Stats::
Index: T_IDX Col#: 1
LVLS: 1 #LB: 116 #DK: 2 LB/K: 58.00 DB/K: 136.00 CLUF: 273.00
Access path analysis for T
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T[T]
Table: T Alias: T
Card: Original: 63860.000000 Rounded: 31930 Computed: 31930.00 Non Adjusted: 31930.00
Access Path: TableScan
Cost: 97.32 Resp: 97.32 Degree: 0
Cost_io: 96.00 Cost_cpu: 16045533
Resp_io: 96.00 Resp_cpu: 16045533
Access Path: index (AllEqRange)
Index: T_IDX
resc_io: 195.00 resc_cpu: 13203631
ix_sel: 0.500000 ix_sel_with_filters: 0.500000
Cost: 196.08 Resp: 196.08 Degree: 1
Best:: AccessPath: TableScan
Cost: 97.32 Degree: 1 Resp: 97.32 Card: 31930.00 Bytes: 0
***************************************
============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 97 | |
| 1 | TABLE ACCESS FULL | T | 31K | 811K | 97 | 00:00:02 |
-------------------------------------+-----------------------------------+
Predicate Information:
----------------------
1 - filter("ID"=:FID)
Content of other_xml column
===========================
db_version : 11.2.0.1
parse_schema : TEST
plan_hash : 1601196873
plan_hash_2 : 2498539100
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=852
char format=1
max length=32
value=2
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
DB_VERSION('11.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 0)
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "T"@"SEL$1")
END_OUTLINE_DATA
*/
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/19423/viewspace-667815/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 程式中使用繫結變數，執行計劃不正確變數
- 執行計劃繫結
- 【CURSOR】Oracle繫結變數、執行計劃對遊標的影響Oracle變數
- Event 10053 執行計劃 繫結變數 Bind peeking變數
- sqm執行計劃的繫結
- Oracle-繫結執行計劃Oracle
- 如何解決執行計劃繫結變數bind peeking重新硬解析變數
- [20231210]執行計劃與繫結變數.txt變數
- 怎樣看懂Oracle的執行計劃Oracle
- java程式裡怎麼使用繫結變數Java變數
- 執行計劃沒變，執行時快時慢是怎麼回事？
- sqlprofile繫結執行計劃實驗測試SQL
- 知識篇 | ORACLE 如何執行計劃繫結Oracle
- oracle10g_11g_繫結變數bind_與最優執行計劃explain planOracle變數AI
- 【優化】使用繫結變數 OR 不使用繫結變數，這不是問題！優化變數
- 怎樣得到準確的執行計劃
- 怎樣看懂Oracle的執行計劃[轉]Oracle
- 【最佳化】使用繫結變數 OR 不使用繫結變數，這不是問題！變數
- 怎麼穩固執行計劃<轉>
- 在資料分佈嚴重不均的列上使用繫結變數容易錯過更好的執行計劃變數
- 求助? 怎麼在jboss下執行servletServlet
- 繫結變數變數
- 關於繫結變數的SQL繫結什麼值變數SQL
- PostgreSQL執行計劃變化SQL
- oracle 執行計劃變更Oracle
- 繫結變數之繫結變數窺探(Bind Peeking)變數
- 繫結變數就一定好麼變數
- Oracle SQL_Profile手動生成及繫結sql執行計劃OracleSQL
- 使用spm繫結執行計劃來線上優化資料庫優化資料庫
- Oracle 繫結變數Oracle變數
- 統計沒有繫結變數SQL變數SQL
- sql執行計劃是否改變SQL
- 使用hint改變執行計劃
- Oracle利用coe_load_sql_profile指令碼繫結執行計劃OracleSQL指令碼
- 通過ERRORSTACK找出正在執行的SQL中的繫結變數值ErrorSQL變數
- 檢視繫結變數變數
- 繫結變數窺測變數
- PLSQL使用繫結變數SQL變數