SQL Baseline not used.

From: Bala Krishna <krishna000_at_gmail.com>
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-l
Received on Sat Nov 22 2014 - 03:29:32 CET

Original text of this message