Hey Rich,
Even enterprise has this bug. We have to patch to oct 2019 psu. Unfortunately
we are only on the July psu so it’s another round of patching for us 😟
Cheers,
Leng
On 3 Dec 2019, at 3:15 am, Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx> wrote:
Hey Leng,
On 2019/11/24 16:46, Leng wrote:
Check out bug 28831971.8
On 23 Nov 2019, at 1:51 am, Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>Hey all,
wrote:
I had noticed that RAM usage was slowly increasing on the OL7.4 server
running 18 XE (and a host of other things) and tracked it down to the CJQ0
process. Recording PGA usage hourly as shown in V$PROCESS for the past 40+
days, the PGA_ALLOC_MEM of the CJQ0 process increased by 4.2MB/day on
average with little deviation. That sure smells like a memory leak to me.
The XE instance has the sole user PDB, with only the default jobs in the
CDB and APEX and 1 other job scheduled in the PDB. JOB_QUEUE_PROCESSES was
the default of 4000 (seems a tad high for a default).
That bug certainly does seem to fit, and my workaround also appears to be
working. Looks like a weekly cron job from now on. Eh, it's the price of
using free Oracle I guess.
Thanks!
Rich