SQL Baseline not used.
Date: Fri, 21 Nov 2014 21:29:32 -0500
Message-ID: <CAG+FZajHRJvZFPKBEib-zdVicYG5fu2mpG=ie3cUUy1R9WwyLg_at_mail.gmail.com>
Hi All,
I've created a tuning task
dbms_sqltune.create_tuning_task(task_name=>'&&Task_name', sql_id=>'&sql_id', time_limit=>&time_limit);
Tuning Task reported to create a sql plan baseline, i've created that but only for the first time it used and executed fast. For the next run it created a different plan_hash_value and may be because of that Sql Baseline not used.
I've not fixed Sql Baseline that i have created it.
Can somebody please answer me following questions.
1.If the cached SQL in shared pool flushes out will it not use created SQL
Baseline anymore?
2.I have to fix the plan permanently irrespective of Gather Stats ran on
the underlying tables weekly or whatever the reason i'd like to fix the
plan that has given the proven results.
3.How do i retrive the plan and fix it for permanent use.
Regards
Bala
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Nov 22 2014 - 03:29:32 CET