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,

 

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

Legend

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