SQL*Plus ARRAYSIZE Posted on July 16, 2010, updated on May 27, 2019 by Yannick JaquierTable of contents Preamble Testing ARRAYSIZE = 15 ARRAYSIZE = 200 Summary and conclusion SQL*Net further configuration 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
PGA and SGA sizing Posted on July 13, 2010, updated on January 26, 2016 by Yannick JaquierTable of contents Preamble PGA used by processes How to increase PGA per process 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
AIX basic commands Posted on June 3, 2010, updated on September 2, 2021 by Yannick JaquierTable of contents AIX release General hardware information Process scheduler General AIX performance tools In depth tools Trace based tools Generic monitoring Memory monitoring I/O monitoring Network monitoring CPU monitoring File system defragmentation References Continue reading