Rob Fitzpatrick
ProgressTalk.com Sponsor
Hi all,
A client of mine is experiencing some read performance issues and so is revisiting everything about their system configuration.
Production DBs are 180 GB and 90 GB. -B is 50 GB and 19 GB respectively. They are on AIX 7.1, OE 11.6.1. Structure is good, Type II areas. In short, startup parameters are all reasonable. Storage is on IBM SAN. Tuning for incremental gains is possible but I have dealt with the low-hanging fruit. ABP is in use but is not configured properly; I will be dealing with that separately. One table in particular is 52 GB and I have reason to believe it has a high degree of logical scatter and needs a D&L; that is in the planning stages.
They are asking me specifically about tuning OS kernel parameters. As my experience is mostly on Linux and Windows I don't have any insights to offer. Are there any suggestions you can offer on settings you typically apply for a database workload? Thanks in advance.
A client of mine is experiencing some read performance issues and so is revisiting everything about their system configuration.
Production DBs are 180 GB and 90 GB. -B is 50 GB and 19 GB respectively. They are on AIX 7.1, OE 11.6.1. Structure is good, Type II areas. In short, startup parameters are all reasonable. Storage is on IBM SAN. Tuning for incremental gains is possible but I have dealt with the low-hanging fruit. ABP is in use but is not configured properly; I will be dealing with that separately. One table in particular is 52 GB and I have reason to believe it has a high degree of logical scatter and needs a D&L; that is in the planning stages.
They are asking me specifically about tuning OS kernel parameters. As my experience is mostly on Linux and Windows I don't have any insights to offer. Are there any suggestions you can offer on settings you typically apply for a database workload? Thanks in advance.