Explore >> Select a destination
|
You are here 
|
www.bobbydurrettdba.com | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Conclusion When using the merge command to process small amounts of data be careful that you don't manage to enable parallel DML or you may find that you add a lot of empty space to the object. This could become very wasteful if you were running a loop that processed a few rows on every... | |
| | | | |
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... | |
| | | | |
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... | |
| | | | |
janik6n.net
|
|
| | | ?? Cloud Advisor, Architect & Developer ?? Reading, learning & MTB | ||
