Oracle Solution for Error ora-01037

Solution for Oracle Error ORA-01037

ORA-01037: maximum cursor memory exceeded

What triggered the Error:

Attempting to process a complex sql statement which consumed all available memory of the cursor.

What should we do to fix it:

Simplify the complex sql statement.