A just really urgent question: It's 11gR2, opening lots of child cursors for one UPDATE statement. Its shareable, but not bind aware. After several minutes if have more than 1000 child cursors!
Due to that, I have huge CPU load from "cursor: mutex s" waits
Does anyone have an advice for me?
(Oracle SR already opened, but no answer yet)