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>



_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-l
Received on Thu Feb 04 2021 - 18:44:48 CET

Original text of this message