Hi all,
I'm running the 7.4.3.14 database instance under very heavy load.
(REDO LOG is switched OFF with SET LOG WRITER OFF)
I've checked the collision rates on the different regions and find out the following line
in the output of the "show regions" command:
"30 SERVER 237 0 200 2 0 84.39 %"
I have no idea what resource is protected through this "region" (as I understand
region means a named spin-lock) and if this high collision rate might slow down
the performance. As I know in general the high collision rates on access to the
shared resources might be a serious problem. That's why I'm interested to know if
this is a problem and if there are any parameters/limitations that might affect this
value?
Thanks in advance.
Dmitri Lyssenko,
Nuix. Pty. Ltd.
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
