Oracle 23c New Features for DBA'sAdaptive cursor sharing as you all aware , This was introduced in 11gR1 to address issues related to bind variable peeking. See support note 740052.1 and documentation for details.
You may have weird behaviors of your sql’s after upgrade to 11g , this may be due to no proper testing done, or optimizer features that came with 11g like ACS etc.
To disable the Adaptive cursor sharing if you want , According to support note 11657468.8
, Set the following two parameters
_optimizer_adaptive_cursor_sharing = false,
_optimizer_extended_cursor_sharing_rel = "none"
alter system set “_optimizer_adaptive_cursor_sharing = false”;
alter system set “_optimizer_extended_cursor_sharing_rel” = "none";
Or you can do at session level as well.
alter session set “_optimizer_adaptive_cursor_sharing = false”;
alter sesssion set “_optimizer_extended_cursor_sharing_rel” = "none";
-Thanks
Geek DBA
Follow Me!!!