Explanation

The rate of lock collisions is high. Tasks that run in different threads are attempting to access a global storage area in parallel. The synchronization required for this often leads to an increased collision rate.

User Response

You need to act if the collision rate rises above 10%. Generally, the risk of collision rises with the number of processors used (MaxCPUs general database parameter). In multiprocessor systems, you should therefore check whether the database system can fulfill the needs of the applications with fewer CPUs.

If high collision rates occur in multiprocessor central systems (database system and application running on the same computer), check whether the computer’s CPU is overloaded, and whether the database threads are blocked by other applications. In this case, the database threads that contain user tasks should have received REAL TIME PRIORITY in the operating system. To avoid operating system blocks however, the value of MaxCPUs must be at least one lower than the number of actual CPUs.