cursor_sharing

 Hello.

In one of my databases I see a large number of SQLs that looks the same except for one value (select col1 from tab1 where col2=1 select col1 from tab1 where col2=2 etc).  I have mentioned to the app team about the bind variables, but in the meantime, oracle's recommendation in the ADDM report is cursor_sharing to be set to force. We did that in a test environment once and the results appears to be positive. However I am a little reluctant to try in in production because our test environment is not very close to prod and I also