Re: batch process runs slower and slower over time

  • From: Ls Cheng <exriscer@xxxxxxxxx>
  • To: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
  • Date: Thu, 17 May 2012 21:37:26 +0200

I took PGA heapdumps and also monitored PGA during execution.

PGA was increasing and decreasing all the time (but always end up
increasing a bit), the process started with like 20MB PGA allocated, after
12 hours it had 150MB allocated.

Let me check the memory leak issues in this version and see if we have some
potential bug and check the PL/SQL code and see if the arrays are being
used properly



Other related posts: