Re: How to drop a plan_hash_value from shared pool
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 17 Sep 2019 16:16:49 -0400
Message-ID: <f8dffebe-20e7-cde8-8da3-e292bd344628_at_gmail.com>
Date: Tue, 17 Sep 2019 16:16:49 -0400
Message-ID: <f8dffebe-20e7-cde8-8da3-e292bd344628_at_gmail.com>
On 9/17/19 3:51 PM, Eriovaldo Andrietta wrote:
> The application does not have a bind for the query (I ask to put it,
> it is very important), so each execution generate a new sql_id.
>
What you are looking for is not possible. Oracle takes a SQL and
computes SQL_ID. Please look at the following article from Tanel Poder:
https://blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value/
You can change a character in the SQL, that will generate new hash and new SQL_ID.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 17 2019 - 22:16:49 CEST