Error: CKPT (OSPID : 383463) waits for event 'rdbms ipc reply' for 223 secs.

Diagnose

Checking: ( Top Wait Event of CKPT)

select event, state, count(*) from v$session_wait group by event, state order by 3 desc; SELECT filename, status, bytes FROM v$block_change_tracking;

Solutions

alter system set "_bct_buffer_allocation_max"=1073741824 scope=both sid='*';

alter system set "_bct_public_dba_buffer_maxsize"=1073741824 scope=both sid='*'

alter system set "_bct_public_dba_buffer_size"=1073741824 scope=both sid='*';

Error Message