Automatic Diagnostic Repository (ADR) Posted on September 27, 2010, updated on June 25, 2015 by Yannick JaquierTable of contents Automatic Diagnostic Repository ADRCI Continue reading
oradebug extended Posted on July 20, 2010, updated on October 16, 2023 by Yannick JaquierTable of contents Preamble Oradebug References Continue reading
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
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