Tracnac/SQL Stability.md

Created September 23, 2022 16:37

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Tracnac/a453c6eec7769cd76c803ab86fb33652.js"></script>
Save Tracnac/a453c6eec7769cd76c803ab86fb33652 to your computer and use it in GitHub Desktop.

Download ZIP

SQL Stability #oracle #performance

Raw

SQL Stability.md

alter system set "_optimizer_adaptive_cursor_sharing"=FALSE scope=both sid='*';
alter system set "_optimizer_extended_cursor_sharing_rel"='NONE' scope=both sid='*';
alter system set "_optimizer_extended_cursor_sharing"='NONE' scope=both sid='*';
alter system set "_OPTIMIZER_USE_FEEDBACK"=FALSE scope=both sid='*';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment