This discussion is archived
0 Replies Latest reply: Aug 8, 2013 3:02 AM by IamHariKrishna RSS

how to check bind peeking is happening for a sql

IamHariKrishna Newbie
Currently Being Moderated

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.






  • Correct Answers - 10 points
  • Helpful Answers - 5 points