Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Memory error on Oracle execution

User_RFKSXAug 28 2020 — edited Sep 1 2020

Hi,

I've got a package that elaborates XML documents. The package runs shedulated daily but after a few weeks, now every day it gives errors like:

ORA-04030: out of process memory when trying to allocate 4032 bytes (qmxdGetDocElem,qmemNextBuf:alloc)

ORA-04030: out of process memory when trying to allocate 1032 bytes (qmxlu subheap,qmemNextBuf:alloc)

ORA-04030: out of process memory when trying to allocate 40 bytes (kxs-heap-f,frame segment)

and I've never met such errors.

If I try to perform manually the package in other moments it works and terminates reguraly.

Can someone give me some suggestion? What about this type of errors? I work on Oracle 10g

Thanks in advance!

Mark

This post has been answered by L. Fernigrini on Aug 28 2020
Jump to Answer
Comments
Post Details
Added on Aug 28 2020
9 comments
1,117 views