Oracle DBA, How To, Error, Cause and Action

ORA-01037: maximum cursor memory exceeded

ORA-01037: maximum cursor memory exceeded




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




Action: Simplify the complex sql statement.