Norman Biggar
Member
Our database has BIW and AIW, plus 3 APW.
We consistently see Writes by BIW or AIW of less than 10%. I imagine this means that something else is doing the other 90% of the work.
I've read suggestions that reducing the biblocksize will improve these figures, but we cannot set this any lower as it is already the same size as the database blocksize.
I feel that I'm not getting the full benefit of these dedicated servers and was wondering if anyone could suggest a way of improving their performance.
If it helps, we have
biclustersize 512 bytes
16 bibufs
25 aibufs
8K dbblocksize and biblocksize
We consistently see Writes by BIW or AIW of less than 10%. I imagine this means that something else is doing the other 90% of the work.
I've read suggestions that reducing the biblocksize will improve these figures, but we cannot set this any lower as it is already the same size as the database blocksize.
I feel that I'm not getting the full benefit of these dedicated servers and was wondering if anyone could suggest a way of improving their performance.
If it helps, we have
biclustersize 512 bytes
16 bibufs
25 aibufs
8K dbblocksize and biblocksize