Re: high Block change tracking waits
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 4 Feb 2021 17:44:48 +0000
Message-ID: <CAGtsp8n4i9f308L2t35ugHN4GKrnAO_f-UhzWrqm-1nX5ZXhiw_at_mail.gmail.com>
Date: Thu, 4 Feb 2021 17:44:48 +0000
Message-ID: <CAGtsp8n4i9f308L2t35ugHN4GKrnAO_f-UhzWrqm-1nX5ZXhiw_at_mail.gmail.com>
_at_ VinÃcius Fernandes
Are you sure you're not mixing block change tracking with flashback logging
?
The size of the flashback log buffer is (maybe was) tied to the size of the
redo log buffer with flashback log buffer = 2 * redo log buffer
Regards
Jonathan Lewis
On Thu, 4 Feb 2021 at 17:04, VinÃcius Fernandes <viniciusfmc_at_gmail.com> wrote:
> At least in 12c, the _bct_public_dba_buffer_size max size is the same of
> log_buffer. In some way these 2 memory structures are linked. I had
> problems to increase the value and there wasn't any doc saying about this
> link.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 04 2021 - 18:44:48 CET