SQL>exec :a :=3
PL/SQL procedure successfully completed.
SQL>col PREDICATE for a10
SQL>-- 选择率
SQL>SELECT hash_value, sql_id, child_number, predicate, range_id, low, high
2 FROM v$sql_cs_selectivity
3 WHERE sql_id='56g5zg95hcxc1'
4 ORDER BY sql_id, child_number;
SQL_ID CHILD_NUMBER PREDICATE RANGE_ID LOW HIGH
--------------- ------------ ---------- ---------- -------------------- --------------------
56g5zg95hcxc1 1 =A 0 0.810076 0.990093
56g5zg95hcxc1 2 =A 0 0.000007 0.000009
56g5zg95hcxc1 3 =A 0 0.000007 0.099008
SQL>select count(object_id) from t where id=:a;
COUNT(OBJECT_ID)
----------------
9999
SQL>-- 选择率
SQL>SELECT hash_value, sql_id, child_number, predicate, range_id, low, high
2 FROM v$sql_cs_selectivity
3 WHERE sql_id='56g5zg95hcxc1'
4 ORDER BY sql_id, child_number;
SQL_ID CHILD_NUMBER PREDICATE RANGE_ID LOW HIGH
-------------- ------------ ---------- ---------- -------------------- --------------------
56g5zg95hcxc1 1 =A 0 0.810076 0.990093
56g5zg95hcxc1 2 =A 0 0.000007 0.000009
56g5zg95hcxc1 3 =A 0 0.000007 0.099008
SQL>SELECT child_number, executions, buffer_gets, is_bind_sensitive,
2 is_bind_aware,IS_SHAREABLE
3 FROM v$sql
4 WHERE sql_id='56g5zg95hcxc1';
CHILD_NUMBER EXECUTIONS BUFFER_GETS IS IS IS
------------ ---------- ----------- -- -- --
0 2 13690 Y N N
1 1 13162 Y Y Y
2 1 4 Y Y N
3 2 1495 Y Y Y
|