Performance Issue For Audit Vault Streams Replication - 184.108.40.206
Last updated on FEBRUARY 06, 2018
Applies to:Oracle Audit Vault and Database Firewall - Version 220.127.116.11 and later
Information in this document applies to any platform.
Performance issue for Audit Vault Streams replication: cannot keep up with the changes from source database because it is limited by flow control (event: REPL Capture/Apply: flow control)
Increasing streams_pool_size, SGA for Capture and Apply components (by setting _SGA_SIZE) or increasing parallelism did not help.
Also tried using PARALLELISM=1 to get rid of the enq: TM contention event of background processes at the target site, but this did not help with the flow control.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms