Database Reference
In-Depth Information
128: use hash partitioning dimension
256: use range partitioning dimension
2048: use list partitioning dimension
1024: run the join in serial
0: invalid distribution method
sel - selectivity
ptn - partition
Results of Bind Variable Peeking
This section contains all the bind variables used in the query, their data types (
oacdty
), and
values. The output is identical to the format of an extended SQL trace with event 10046 at levels
4 or 12.
*******************************************
Peeked values of the binds in SQL statement
*******************************************
kkscoacd
Bind#0
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=178 siz=32 off=0
kxsbbbfp=04c3ae00 bln=32 avl=19 flg=05
value="South San Francisco"
Optimizer Parameters
This section holds a listing of 184 documented and hidden parameters, which affect the
optimizer's calculations and decisions, and is organized into three subsections:
1.
Parameters with altered values.
2.
Parameters with default values.
3.
Parameters supplied with the hint
OPT_PARAM
(e.g.,
OPT_PARAM('optimizer_index_cost_
adj' 30)
). This undocumented hint may be part of stored outlines.
Subsections 1 and 3 from the example trace file are empty, since all parameters had
default values.
***************************************
PARAMETERS USED BY THE OPTIMIZER
********************************
*************************************
PARAMETERS WITH ALTERED VALUES
******************************
*************************************
