Trying to find out overhead of new Adaptive Query Optimization feature
use perf to find out process cpu usage ( eg:perf stat -e task-clock -p 9576 sleep 5 )
to disable adaptive features I used
alter system set optimizer_features_enable='11.2.0.1';
|
3000 hpares |
3000 hpares |
3000 hpares |
3000 hpares |
3000 hpares |
avg |
adaptive off |
1724,46 |
1786,04 |
1696,22 |
1687,89 |
1690,89 |
1717,10 |
adaptive on |
1803,79 |
1815,98 |
1966,07 |
1804,35 |
1819,35 |
1841,91 |
overhead |
4,40 |
1,65 |
13,73 |
6,45 |
7,06 |
6,78 |