I've got a set of database (6 in fact) running with 2 phase commit in 9.1E04 on a Solaris 10 zone and I'm trying to do some general performance tuning (you know, the old "can you make it run any faster without changing the code"). The one item that I can't really find anything on is groupdelay and I was wondering if there are any pointers etc? Its currently set to 20 on all DBs.
I've never found it useful.
If it is set to 20 is -Mf also set to 0?
Yes it is
Have you noticed that it makes any difference vs the default values?
No - I've tried setting "groupdelay" from 5 to 40 in increments of 5 and have not seen any difference. The -B is big enough to hold all the data it needs etc.