Re: 18XE memory leak in CJQ0

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_at_society.servebeer.com> wrote:
>
> 

>> 
>> On 2019/11/24 16:46, Leng wrote:
>> 
>> Check out bug 28831971.8
>> 
>>>> On 23 Nov 2019, at 1:51 am, Rich J <rjoralist3_at_society.servebeer.com> wrote:
>>>> 
>>> Hey all,
>>> 
>>> 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).
>>> 

--
http://www.freelists.org/webpage/oracle-l