We have AWR Report have different sql id for the same SQL since it seems different in space near BIND VARIABLES.
We have checked in Application team on passing Bind variables, there is no difference. Why this happens. Can anyone please clarify
BEGIN RATING_PKG.GET_CAP_AGREEMENT_RATE(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 ); END;
BEGIN RATING_PKG.GET_CAP_AGREEMENT_RATE(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31); END;
Similarly other queries also.
We have enabled the CURSOR SHARING to FORCE also.
|