1 Reply Latest reply: Jun 21, 2013 12:48 AM by Karthick_Arp RSS

    ORA-04030: out of process memory when trying to allocate 1647512 bytes

    jananibaalasubramanian

      Hi All,

       

      I have a problem in a PL/SQL procedure. The procedure runs and before getting fully completed, a buffer error "ORA-04030: out of process memory when trying to allocate 1647512 bytes" is thrown.So the process gets ended abruptly without completing.Hence few SQL's are not being completed.

       

      So can anyone help me in giving a thought or solution to solve this error.