ORA-01037

Error: ORA-01037: maximum cursor memory exceeded

Causa: An attempt was made to process a complex SQL statement which consumed all available memory of the cursor.

Acción: Simplify the complex SQL statement. Alternatively, you can use the NO_EXPAND hint which prevents the cost-based optimizer from considering OR-expansion for queries having OR conditions or INLISTS in the WHERE clause. Usually, the optimizer considers using OR expansion and uses this method if it decides the cost is lower than not using it. Refer to the Oracle9i Database Performance Tuning Guide and Reference for information about using hints.