0 Replies Latest reply on Aug 8, 2013 10:02 AM by IamHariKrishna

    how to check bind peeking is happening for a sql


      Hi Team,

     , RHEL-6 on 64 bit, 2 node RAC.


      We have been continuously facing performance issues after upgraded to 11g. sqls were fine when we are in 10g and they started following un-optimized plans. I heard that 'automatic cursor sharing' is enabled by  default in 11gr2. But how do we verify, whether a sql id peeking at its binds ? Can somebody share the query if you have ?


      And also, any useful links regarding this pls suggest me.