|
You are here |
www.bobbydurrettdba.com | ||
| | | | |
mahmoudhatem.wordpress.com
|
|
| | | | | Since oracle 12.2.0.1 Adaptive Dynamic Sampling result are stored inside SPD as a special directive type "DYNAMIC_SAMPLING_RESULT". This will allow the result of ADS to be persisted on disk,thus it will survive memory flush and database restart.For more detailed info please check Mauro Pagano blog Post Something new about SQL Plan Directives and 12.2 We... | |
| | | | |
mwidlake.wordpress.com
|
|
| | | | | 1 post published by mwidlake on July 3, 2009 | |
| | | | |
mauro-pagano.com
|
|
| | | | | 12c brought several new features in the SQL performance area and the most advertised one is probablyAdaptive Query Optimization. The Adaptive Plans feature has been described in a lot of details (specially the adaptive join methods part) and most of the focus in Adaptive Statistics has been on SQL Plan Directives and Automatic Re-optimization, not... | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | |||