Performance Issue For Audit Vault Streams Replication - 12.2.0.7

(Doc ID 2350183.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.2.0.5 and later
Information in this document applies to any platform.

Symptoms

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)

Changes

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.

Cause

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