j_meca
asked on
ora-6500 storage error
I obtain the next error:
ORA-06500:PL/SQL STORAGE ERROR
ORA-04030: INSUFICIENT MEMORY TO ALLOCATE 16396 BYTES(KOH-KGHU SESSI:ADT RECORD)
ORA-06512:IN "LIBRA.PK_INFOR_CMF", LINE 2
ORA-06500:PL/SQL STORAGE ERROR
ORA-04030: INSUFICIENT MEMORY TO ALLOCATE 16396 BYTES(KOH-KGHU SESSI:ADT RECORD)
ORA-06512:IN "LIBRA.PK_INFOR_CMF", LINE 2
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.
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.
ASKER
How can i increase the amount of memory? the pga memory...isn´t it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a lot