Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Connection Management
  5. JDBC Client Configuration
  6. ODBC Client Configuration
  7. Access Control
  8. Logs
  9. High Availability
  10. Server Control
  11. Performance Tuning
  12. Troubleshooting

Administrator Guide

Administrator Guide

Dynamic Data Masking Resource Consumption

Dynamic Data Masking Resource Consumption

Dynamic Data Masking consumes CPU resources to process connections, rewrite requests, and store logs. The CPU consumption is linearly proportional to the SQL *Net traffic that the Dynamic Data Masking service routes. You can use the SQL *Net and DBlinks traffic values to estimate the amount of CPU that the Dynamic Data Masking service consumes.
The Dynamic Data Masking resource consumption is approximately 1% of the server CPU and has no I/O overhead. The Dynamic Data Masking service requires approximately 1 GB for memory and some disk space for logs.
To calculate the CPU consumption, you must determine the round-trip value, which is the total packet traffic that a client and server sends and receives each second. The total round-trip value includes SQL *Net traffic and DBlinks.
Use the following variables and equations to calculate the CPU consumption:
Variables
X1 = SQL *Net round-trip value
X2 = DBlinks round-trip value
PR = Total round-trip packets for each second
Equations
PR = (X1+X2)*2
CPU Consumption = PR/10,000

0 COMMENTS

We’d like to hear from you!