Statement (Java Platform SE 7 ) - Oracle
Ask Tom sql loader - Oracle
Also he had a nice script for pulling the hints from VSQL _PLAN table which I have made use of as well. So as always I have created a few scripts (borrowing from Randolf mostly). I posted about Oracles. SQL Tuning Advisor a while back. Its a feature that was added to Oracle in version 10g. It basically looks a SQL statement and tries to come up with a better execution plan than the one the optimizer has. Note that youll have to use a different category, then drop the original, then enable the new SQL Profile. Which means this approach is a bit more work than just creating an Outline in the DEFAULT category. The object used for executing a static SQL statement and returning the results it produces. By default, only one ResultSet object per Statement object can be open at. PROFILE _0qa98gcnnza7h DEFAULT ENABLED select avg(pk_col) from ew NO SQL set echo on SQL @sql_profile_hints SQL set lines 155. SQL col hint for a150 SQL select attr_val hint 2 from dba_sql_profiles p, sqlprofattr h 3 where gnature gnature 4 and name like profile_name.
Outlines dont appear to use the OPT_ESTIMATE hint. So I believe it is still a valid approach to accept a SQL Profile as offered by the SQL Tuning Advisor and then create an Outline on top of it.
Sql statement ignored error in oracle
When its all done, if it has found a better plan, it offers to implement that new plan via a SQL Profile. Those offered Profiles often have a lightly documented hint (OPT_ESTIMATE ) that allows it to scale the optimizer estimates for various.
Written by: Антип
4,5 / 5 stars