Link to home
Start Free TrialLog in
Avatar of j_meca
j_mecaFlag for Spain

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
Avatar of j_meca
j_meca
Flag of Spain image

ASKER

I need to know if it is a database parameter error (all my applications works fine except a new inform process that generates the error) or if it is a programmer error.

thanks a lot
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.
Avatar of j_meca

ASKER

How can i increase the amount of memory? the pga memory...isn´t it?
ASKER CERTIFIED SOLUTION
Avatar of shru_0409
shru_0409
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial