Re: How to drop a plan_hash_value from shared pool

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 17 Sep 2019 22:20:09 +0000
Message-ID: <CWXP265MB1750D8848812AC11EC26AF65A58F0_at_CWXP265MB1750.GBRP265.PROD.OUTLOOK.COM>

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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Andy Klock <andy_at_oracledepot.com> 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_at_gmail.com<mailto:ecandrietta_at_gmail.com>> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 18 2019 - 00:20:09 CEST