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
Database Resource Manager (DBRM) to manage and prioritize resources Posted on July 14, 2010 , Modified on May 2, 2018 , by Yannick JaquierTable of contents Preamble Database resource manager configuration Database resource manager testing References Read more Oracle Database Resource Manager (DBRM), Tuning 1 comment
HP Process Resource Manager (PRM) Posted on July 2, 2010 , Modified on June 9, 2026 , by Yannick JaquierTable of contents Preamble Configuration CPU testing Memory testing Private memory Shared memory Disk testing Useful commands References Read more HPUX Process Resource Management (PRM), Tuning 3 comments
AIX Oracle tuning Posted on June 15, 2010 , Modified on October 27, 2026 , 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 Read more AIX, Oracle Tuning 12 comments