CURSOR_SHARING initialization parameter tips and tricks Posted on January 6, 2011, updated 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 Continue reading
Database Resource Manager (DBRM) to manage and prioritize resources Posted on July 14, 2010, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Database resource manager configuration Database resource manager testing References Continue reading
HP Process Resource Manager (PRM) Posted on July 2, 2010, updated on April 19, 2022 by Yannick JaquierTable of contents Preamble Configuration CPU testing Memory testing Private memory Shared memory Disk testing Useful commands References Continue reading
AIX Oracle tuning Posted on June 15, 2010, updated on September 2, 2021 by Yannick JaquierTable of contents Preamble Environment variables Maximum number of processes VMM tuning VMM background maxclient% maxperm% minperm% lru_file_repage page_steal_method Memory monitoring LOCK_SGA Large page memory Asynchronous I/O Concurrent I/O Filesystems tuning I/O monitoring References Continue reading
MySQL Initialization Parameters Tuning Posted on October 7, 2009, updated on June 25, 2015 by Yannick JaquierTable of contents Preamble Generic parameters Generic memory parameters Optimizer parameters Binary logging MyISAM InnoDB Query cache Recommended MySQL initialization parameters for InnoDB data model Continue reading