Re: Backroom process tt00 top process

Hello Jeff,

Yes you can kill the TT process and oracle will spawn a new one. But before doing that try this to see what is doing on CPU:

perf record -g -F 99 --pid pid_number
-> this will generate a perf.data file (let it run few minutes and hit ctrl-c)
get : https://github.com/brendangregg/FlameGraph and run:
perf script | ./FlameGraph-master/stackcollapse-perf.pl | ./FlameGraph-master/flamegraph.pl > TT.svg You can send the resultate flamegraph

În mar., 13 apr. 2021 la 18:38, Jeff Chirco <backseatdba_at_gmail.com> a scris:

> Thanks for those Doc IDs. Those look like they have a symptom of high PGA
> usage. For me PGA is looking fine but this process is consuming high CPU.
> Would anything happen if I killed that session? Would another respawn?
>
> On Sun, Apr 11, 2021 at 9:10 PM Leng Burgess <lkaing_at_gmail.com> wrote:
>
>> Hi Jeff,
>>
>> Check out these bugs:
>>
>> Bug 28831971 - PGA Memory Leak On Background Processes Such As MMNL TT00
>> Or +APX (Doc ID 28831971.8)
>> Bug 30719327 - PGA memory leak in TT00, MMNL, and other background
>> process with patch 28831971 APPLIED (Doc ID 30719327.8)
>>
>> HTH,
>>
>> Leng.
>>
>> > On 10 Apr 2021, at 6:08 am, Jeff Chirco <backseatdba_at_gmail.com> wrote:
>> >
>> > I am running TOP and I am seeing ora_tt00 backroom process at the top
>> of list consistently (sorting by CPU), I mean it is at the top steadily. I
>> understand that this has something to do with Redo Transport but I am not
>> sure in what regards and if there is anything I can or should do about it.
>> I have 2 databases on this same server both running Data Guard but this
>> process is showing for only one of the databases. I think both databases
>> are kind of equal on activity.
>> >
>> > Anything else I should be looking at?
>> >
>> > Thanks,
>> > Jeff
>>
>>

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