Home » SQL & PL/SQL » SQL & PL/SQL » AWR Report SQL with Bind Variables (Oracle Version 12.1)
AWR Report SQL with Bind Variables [message #678014] Thu, 31 October 2019 07:47 Go to previous message
kohila
Messages: 2
Registered: October 2019
Junior Member
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ALTER TABLE STATEMENT FOR CLUSTER
Next Topic: Ajuda com procedure Type Pipilined
Goto Forum:
  


Current Time: Mon Dec 09 12:58:19 CST 2019