/explore
|
You are here 
|
stevenwoodson.com | ||
| | | | |
jonathanlewis.wordpress.com
In an earlier articleI described how dbms_xplan.display_cursor() could be used to query memory to find the execution plans (and row source statistics) of recently executed SQL. In 9i, you have to use your own SQL to get the equivalent results. If you do, you should avoid using the "traditional" hierarchical type of query that you... |
|
| | | | | ||
| | | | |
rwijk.blogspot.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... |
|
| | | | | ||
| | | | |
dontcodetired.com
Don't Code Tired - Jason Roberts on Software Development and .NET - This is the fifth part in a series demonstrating how to setup continuous deployment of an Azure Func |
|
| | | |||
