Re: SQL Profile in Oracle Glossary - is this actually correct?
Date: Fri, 17 Jun 2016 09:17:42 +0200 (CEST)
Message-ID: <1879822480.293046.1466147862949.JavaMail.open-xchange_at_app03.ox.hosteurope.de>
Hey Chris,
please use SQL patches if you want to apply a full set of hints. This is what they are made for and they are also license free for Oracle EE:
* https://blogs.oracle.com/optimizer/entry/how_can_i_hint_a
* https://blogs.oracle.com/optimizer/entry/additional_information_on_sql_patches
There are also scripts to generate the PL/SQL call, e.g. from Kerry Osborne: http://kerryosborne.oracle-guy.com/scripts/create_sql_patch.sql
SQL profiles are initially designed to adjust cardinality (OPT_ESTIMATE) for execution plan steps.
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: _at_OracleSK
> Chris Taylor <christopherdtaylor1994_at_gmail.com> hat am 16. Juni 2016 um 18:57 geschrieben:
>
> When a profile exists, I cannot see how the optimizer will "select better plans", instead the optimizer selects the plan in the profile.
>
> Am I mistaken?
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 17 2016 - 09:17:42 CEST