Tuesday, September 30, 2008

ORA-06500

Cause:
PL/SQL was unable to allocate additional storage. This message normally appears with an ORA-4030 or ORA-4031 error which gives additional information. Sometimes this error can be caused by runaway programs.

Action:
1) Ensure there are no issues or bugs in your PL/SQL program which are causing excessive amounts of memory use.
2) Programatically cause unused objects to be freed (e.g. by setting them to NULL).
3) Increase the amount of shared or process memory (as appropriate) available to you.

No comments: