DSXchange

Posted: **Tue Oct 24, 2006 5:18 am**

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

Posted: **Tue Oct 24, 2006 6:25 am**

Try this result.

Posted: **Tue Oct 24, 2006 7:23 am**

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)