Explore >> Select a destination
|
You are here 
|
carlos-sierra.net | ||
| | | | |
hourim.wordpress.com
|
|
| | | | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | |
| | | | |
oracletoday.blogspot.com
|
|
| | | | | I use STATSPACK extensively for comparing two time periods, comparing a time period to a baseline, monitoring trends and diagnosing perform... | |
| | | | |
mauro-pagano.com
|
|
| | | | | Most of the overall database performance issues (not caused by SQL tuning) are prettycomplex to setup because they require a workload and it takes quite some work to reproduce concurrency in a test environment where at best you got a couple folks testing some new code. Nowadays there are ways to reproduce a realistic workload... | |
| | | | |
nenadnoveljic.com
|
|
| | | Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD. | ||
