Dear PAVB,

Thanks.

Now I have a different question. Let me explain you step by step

(1) Presently the query is running from a middleware without any hint. And making code changes (adding hint) in the middleware requires time. The query has 6 bind variables defined. I located the query in the database with sqlid XXXX.

(2) I am running the same query from sqlplus adding a hint and defining those bind variables like below

variable B6 number;
variable B5 number;
variable B4 number;
variable B3 number;
variable B2 varchar2(20);
variable B1 varchar2(20);
exec :B6 := null;
exec :B5 := null;
exec :B4 := null;
exec :B3 := null;
exec :B2 := null;
exec :B1 := null;

(3) I got a SQLID, e.g YYYY for the query I ran above from sqlplus.

Question

(1) If I capture a baseline using the sqlid (YYYY) above, can I use that plan for the query coming from middleware?Hash_plan is different though.
(2) If not, how to create a baseline for the query coming from middleware with a HINT?

Regards