Database hanging for high version count and SYS_REFCURSOR usage Posted on June 5, 2013 , Modified on October 21, 2026 , by Yannick JaquierTable of contents Initial problem First solution and second problem Second solution References Read more Oracle SQL, Tuning Leave a comment
Moving from UTL_FILE_DIR to directories implementation Posted on January 29, 2013 , Modified on February 9, 2018 , by Yannick JaquierTable of contents Preamble UTL_FILE_DIR Directories Read more Oracle SQL 2 comments
Pipelined functions Posted on May 23, 2012 , Modified on March 1, 2021 , by Yannick JaquierTable of contents Preamble Pipelined functions creation References Read more Oracle SQL 1 comment
Server result cache to improve performance by holding result sets Posted on January 21, 2011 , Modified on May 2, 2018 , by Yannick JaquierTable of contents Preamble Server result cache Manual mode Force mode Table annotations PL/SQL function result cache Client result cache References Read more Oracle SQL, Tuning Leave a comment
Bind variables peeking and Adaptive Cursor Sharing (ACS) Posted on January 14, 2011 , Modified on July 23, 2024 , by Yannick JaquierTable of contents Introduction Testing Before Oracle 11g Starting with Oracle 11g References Read more Oracle Adaptive Cursor Sharing (ACS), SQL, Tuning 1 comment
CURSOR_SHARING initialization parameter tips and tricks Posted on January 6, 2011 , Modified on July 8, 2024 , by Yannick JaquierTable of contents What to do/not do Testing CURSOR_SHARING=exact (default value) CURSOR_SHARING=similar Without histograms With histograms CURSOR_SHARING=force Conclusion References Read more Oracle SQL, Tuning 1 comment