Bind variables peeking and Adaptive Cursor Sharing (ACS) Posted on January 14, 2011, updated on January 26, 2016 by Yannick JaquierTable of contents Introduction Testing Before Oracle 11g Starting with Oracle 11g References Continue reading
CURSOR_SHARING initialization parameter tips and tricks Posted on January 6, 2011, updated on March 26, 2021 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 Continue reading
LogMiner setup and investigation with Oracle 10g and above Posted on June 2, 2010, updated on October 26, 2016 by Yannick JaquierTable of contents Preamble Instantiate LogMiner How to get redo size Redo log block size References Continue reading