Re: 18XE memory leak in CJQ0

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Mon, 02 Dec 2019 10:14:46 -0600
Message-ID: <31465bc7561d1c585ca564a4d4c99248_at_society.servebeer.com>



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

Hey Leng,

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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 02 2019 - 17:14:46 CET

Original text of this message