Re: Odd wait event freezing database

This doc states the wait event as 'enq-ct state' so its not matching with our symptom. And also saying it was fixed in version11.2.

However, with our current symptoms(BCT buffer space waits followed by reliable messages) we have experienced improvements in the past by increasing size of - _bct_public_dba_buffer_size but not any effect with increasing size of _bct_buffer_allocation_max. So trying to understand the difference between these two parameters and why oracle suggests each time to bump _bct_buffer_allocation_max but not the other one( _bct_public_dba_buffer_size) which really helped us in past?

On Sun, Apr 25, 2021 at 5:59 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> There is an even better document to look at:
> Database Instance Hang at Database Checkpoint With Block Change Tracking
> Enabled. (Doc ID 1326886.1) [image: To Bottom]To Bottom
> <https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=73488097211682&id=1326886.1&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=vcjsx6za1_72#>
> ------------------------------
>
> You probably should open a SR with Oracle Support.
>
> On Sun, Apr 11, 2021 at 12:25 AM Lok P <loknath.73_at_gmail.com> wrote
>
>
> High Waits On 'block change tracking buffer space' - Checkpoint Contention
> With BLOCK CHANGE TRACKING or RMAN Incremental Backup (Doc ID 2094946.1)
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
> -- http://www.freelists.org/webpage/oracle-l

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