Same SQL_ID with Different Execution Plans

Few days back i had a discussion with one of my team members regarding same sql_id having different execution plans.So, it was time to login and test myself 🙂 Oracle Database Version --> 11.2.0.1.0 17:01:58 ANAND@MATRIX> show parameter cursor_sharing NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cursor_sharing string EXACT 17:01:59 ANAND@MATRIX> show parameter optimizer NAME TYPE … Continue reading Same SQL_ID with Different Execution Plans

Advertisement