There may be three reasons for the occurrence of frequent locks.

zhaozj2021-02-16  94

There may be three reasons why frequent locks occur in frequent occurrences:

1. Parameter DML_LOCKS is too small

2. The maxTrans parameters of the table are too small (relative concurrency), to modify this parameter must rebuild the table.

3. Some records of the table are often modified concurrently.

转载请注明原文地址:https://www.9cbs.com/read-11793.html

New Post(0)