Re: How to drop a plan_hash_value from shared pool
From: Andy Klock <andy_at_oracledepot.com>
Date: Tue, 17 Sep 2019 16:28:03 -0400
Message-ID: <CADo_RaP1n7qa8MdjfK2Sk_bwe3WSFYopObgqw8a3TDJA5zZTCQ_at_mail.gmail.com>
Date: Tue, 17 Sep 2019 16:28:03 -0400
Message-ID: <CADo_RaP1n7qa8MdjfK2Sk_bwe3WSFYopObgqw8a3TDJA5zZTCQ_at_mail.gmail.com>
On Tue, Sep 17, 2019 at 3:53 PM Eriovaldo Andrietta <ecandrietta_at_gmail.com>
wrote:
> I would like to know how to drop the plan_hash_value , in order to avoid
Andy K
> any sql_id use it again.
> Does it make sense ? or when I drop the plan for the sql_id, a new sql_id
> will generate a new plan_hash_value that can be equal that one dropped ?
>
>
There isn't a way to drop a PHV from Oracle, however, you can try to create
a SQL Profile with force_match=> TRUE. Provided you have TUNING pack, of
course.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 17 2019 - 22:28:03 CEST