Concurrent program-RTF

Posted by satish on Apr 22, 2020; 10:25am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Concurrent-program-RTF-tp8260.html

Dear erman,

I have a general question rtf template.

We are facing intermittent issues with a custom report where few runs are completing normal and few runs are completing with warning with specific arguments.Opp throwing out of memory message in logs.The xml generated is less than 1MB.

We are on R2.1.3 instance with 2GB heapspace defined and we have 3 processes for opp manager with 5 threads each.Many long running requests with large output files are completing without any issues but we are facing issue only with this custom report which runs less than a minute and output file is small.

Have you faced this kind of intermittent issue with any report?what all we can check from dba point of view or is this something a developer can optimize the rtf?

Thank you.