Performance Issue For Audit Vault Streams Replication -

(Doc ID 2350183.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle Audit Vault and Database Firewall - Version 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