Re: Backroom process tt00 top process

From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Tue, 13 Apr 2021 08:38:10 -0700
Message-ID: <CAKsxbLo=+iYygejOTT_uH5X1XHjOd-x5x8vFtMxMbB0LFUQ0eA_at_mail.gmail.com>



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
Received on Tue Apr 13 2021 - 17:38:10 CEST

Original text of this message