Database hanging for high version count and SYS_REFCURSOR usage Posted on June 5, 2013, updated on January 14, 2014 by Yannick Jaquier Table of contents Initial problem First solution and second problem Second solution References Continue reading
Moving from UTL_FILE_DIR to directories implementation Posted on January 29, 2013, updated on February 9, 2018 by Yannick Jaquier Table of contents Preamble UTL_FILE_DIR Directories Continue reading
Pipelined functions Posted on May 23, 2012, updated on June 25, 2015 by Yannick Jaquier Table of contents Preamble Pipelined functions creation References Continue reading
Server result cache to improve performance by holding result sets Posted on January 21, 2011, updated on May 2, 2018 by Yannick Jaquier Table of contents Preamble Server result cache Manual mode Force mode Table annotations PL/SQL function result cache Client result cache References Continue reading
Bind variables peeking and Adaptive Cursor Sharing (ACS) Posted on January 14, 2011, updated on January 26, 2016 by Yannick Jaquier Table of contents Introduction Testing Before Oracle 11g Starting with Oracle 11g References Continue reading
CURSOR_SHARING Posted on January 6, 2011, updated on February 24, 2015 by Yannick Jaquier Table 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 Continue reading