ORA-06500: PL/SQL: storage error

ORA-06500: PL/SQL: storage error
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 to be used. 2) Programmatically 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-06500：PL / SQL：存储错误,
.原因： PL / SQL无法分配额外的存储。此消息通常会出现ORA-4030或ORA-4031错误，提供其他信息。有时这个错误可能是由失控的程序造成的。,
.操作： 1）确保PL / SQL程序中没有导致使用大量内存的问题或错误。2）以编程方式使未使用的对象被释放（例如通过将它们设置为NULL）。3）增加可用的共享内存或进程内存（如适用）。,
.

aiaiDBA

13718043309

010-86462881

ORA-06500: PL/SQL: storage error

1 个回答

相似问题