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

    how to check bind peeking is happening for a sql

    IamHariKrishna

      Hi Team,

       

      11.2.0.3.5, 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.

       

      Thanks,

       

      Hari