Oracle Error ORA-25472: maximum open iterators exceeded

Oracle Error Message

ORA-25472: maximum open iterators exceeded

Reason for the Error

The open rule hit iterators in the session exceeded 2 * OPEN_CURSORS.

Solution

Close some rule hit iterators.