SQL Plan Directives

SQL Plan Directives in 12cR2. Behavior is different than in 12cR1.

During the Frankfurter IT Tage I provided a presentation about SQL Plan Directives and how to reproduce a testcase in a test environment for a plan with used SQL Plan Directives (SPD). In that context I did a couple of(…)

SQL Plan Directives strikes again

By Franck Pachot . 12c SQL Plan Directives, a side effect, a bad application design, a bug... and the occasion to show how to quickly troubleshoot. An application has long response time since 12c migration. No blind guesses, no reason(…)

SQL Plan Directive: disabling usage and column groups

By Franck Pachot . Yesterday I came upon a comment on oracle-l while I was reading my slides for the UKOUG TECH15 SuperSunday. I've one slide and one demo about disabling SPD usage but that's not(…)