G
George Potemkin
Guest
> Now I know I set -pica too high at 16384. > Used HighWater Mark shows that. 16 MB of RAM per db is not a big price for insurance. ;-) > So the goal is that HWM is somehow close to Total Message Entries, like half or more, right? Unfortunately HWM is almost useless without date/time when the message entries had rised to the specified value. It could take place a month ago due to some particular conditions at this time (e.g. abnormal peak of transaction activity, a network issue between source and target dbs etc). The rest of time (untill db restart) you will see a "reminder" about past bad day that does not matter for the current situation. . > Area Filled Count should be small (single digit) or zero? Only zero! Other values would mean that performance on source db was considerably degradated due to a short pica queue at least for some period of time. > Access Collisions ??? It's a field that can be totally ignored.
Continue reading...
Continue reading...