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.