Oracle UPDATE中的神秘笛卡尔积

We have a unique problem in production. Every now and then our Oracle 12c database will hang during our batch cycle in the middle of the night. We will have to restart the database to keep going for a few days/weeks. Then it happens again. After some digging, we have narrowed it down to this SQL:We have a unique problem in production. Every n