There's a quarantine feature in the 19c autonomous database that allows for
"quarantine" of badly behaving statements which, I think, allows for a
particular plan (i.e. plan_hash_value) for a statement to be flagged as
unacceptable. I haven't looked closely at the feature, but I wonder if it is
something that says "if PHV nnnn is generated for SQL_ID xxxxx, don't use it",
or whether it can be set to behave like "force_match". Or maybe it would even
allow a specific PHV to be blocked irrespective of the statement that produced
it.
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Andy Klock <andy@xxxxxxxxxxxxxxx>
Sent: 17 September 2019 23:06
To: Eriovaldo Andrietta
Cc: Chris Taylor; ORACLE-L
Subject: Re: How to drop a plan_hash_value from shared pool
On Tue, Sep 17, 2019 at 5:32 PM Eriovaldo Andrietta
<ecandrietta@xxxxxxxxx<mailto:ecandrietta@xxxxxxxxx>> wrote:
I got the message : There isn't a way to drop a PHV from Oracle
Was a reasonable question though. It's a feature that I wish existed, nearly
every single day. :)
Andy K
--
//www.freelists.org/webpage/oracle-l