SESSION craze caused by a DEGREE

10.1 perform the huge table splite to partition table action. The process went smoothly.

After the program was started, it was found that some reporting programs were slow. The analysis shows that the number of sessions is high, and the active session is not high.

Then we found that the DEGREE parameter of the INDEX is 32, and the result is that the concurrency of the INDEX is too large, resulting in the active session.

And then drop DEGREE to 8, and everything is calm.

DBA_INDEXES