11g cursor sharing

11g  cursor sharing

cursor sharing off
--alter system set "cursor_sharing"=exact scope=both sid='*';
alter system set "_optimizer_extended_cursor_sharing_rel"=none scope=memory sid='*';
alter system set "_optimizer_extended_cursor_sharing"=none scope=memory sid='*';
alter system set "_optimizer_adaptive_cursor_sharing"=false scope=memory sid='*';
alter system set "_optim_peek_user_binds"=false scope=memory sid='*';


cursor sharing on
--alter system set "cursor_sharing"=exact scope=both sid='*';
alter system set "_optimizer_extended_cursor_sharing_rel"=SIMPLE scope=both sid='*';
alter system set "_optimizer_extended_cursor_sharing"=UDO  scope=both sid='*';
alter system set "_optimizer_adaptive_cursor_sharing"=true  scope= both sid='*';
alter system set "_optim_peek_user_binds"=true scope=both sid='*';