Explore >> Select a destination
|
You are here 
|
mauro-pagano.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... | |
| | | | |
nenadnoveljic.com
|
|
| | | | | ORA-07445 [__intel_avx_rep_memcpy()] During a Rowset Operation | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few... | ||
