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> 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).