Hi
I am getting error like this when I am running my job.But this job has run successfully without any warnings before this. Can anyone help me why I am getting it and how can I solve this
J_OBJ_MAXIMO_LOCATIONS_LOAD_upd..XFM_LOCATIONS_LOAD: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-04030: out of process memory when trying to allocate 376 bytes (PRM heap,heap descriptor)
Thanks in advance
mohan
ODCIINDEXUPDATE
Moderators: chulett, rschirm, roy
Start with your DBA.
ODCIIndexUpdate
When a user updates a record, Oracle calls your ODCIIndexUpdate() method, passing it the old and new values in the indexed columns and the corresponding row identifier.
Oracle Error :: ORA-29877
failed in the execution of the ODCIINDEXUPDATE routine
ORA-04030: out of process memory when trying to allocate nn bytes
This is caused by a shortage of RAM on a dedicated (non shared server) environment. Depending on your release of Oracle, you have several options:
Increase pga_aggregate_target
Decrease sort_area_size and/or hash_area_size
Move to multi-threaded server (a.k.a. MTS or shared servers)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers