1. Oracle SQL Firewall User's Guide
  2. Configuring Oracle SQL Firewall
  3. Configuring and Managing Oracle SQL Firewall with the DBMS_SQL_FIREWALL Package
  4. Managing Performance for Capture Logs

2.1.3 Managing Performance for Capture Logs

Depending on application workloads, Oracle SQL Firewall may generate a large volume of capture logs.

To minimize the adverse impact on database performance, Oracle SQL Firewall relies internally on Fast Ingest for better write performance if sufficient memory is available. To make full use of SQL Firewall, Oracle recommends that you do the following:
  • Allocate at least an additional 2G to the LARGE_POOL_SIZE parameter setting, on top of the existing LARGE_POOL_SIZE requirement.
  • Resize the SGA_TARGET parameter setting to include this additional requirement. Ensure that the final size is 8G or more.

Related Topics