RE: Enforcing SQL execution plan

  • From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
  • To: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 3 Sep 2016 17:42:31 +0000

I am not able to find PARAMETERS WITH ALTERED VALUES string in the trace file.

From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx]
Sent: Saturday, September 03, 2016 2:32 AM
To: Hameed, Amir <Amir.Hameed@xxxxxxxxx>; oracle-l@xxxxxxxxxxxxx
Subject: RE: Enforcing SQL execution plan


What does the trace file report under the heading:

PARAMETERS WITH ALTERED VALUES


Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: Hameed, Amir [Amir.Hameed@xxxxxxxxx]
Sent: 02 September 2016 23:42
To: Jonathan Lewis; oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: RE: Enforcing SQL execution plan
I have looked through the entire trace file and could not find opt_param() 
call. The binds captured are shown below:


Other related posts: