To use only masking to evaluate performance:
From the Data Masking Definitions page, select the masking definition to be analyzed, then click Schedule Job.
The Schedule Data Masking Job page appears.
At the top of the page, provide the requisite information.
The script file location pertains to the masking script, which also contains the pre- and post-masking scripts you created in "Pre- and Post-mask Scripts".
In the Encryption Seed section, provide a text string that you want to use for encryption.
This section only appears for masking definitions that use the Substitute or Encrypt formats. The seed is an encryption key used by the encryption/hash-based substitution APIs, and makes masking more deterministic instead of being random.
In the Workloads section:
Select the Mask SQL Tuning Sets option, if desired.
If you use a SQL Tuning Set that has sensitive data to evaluate performance, it is beneficial to mask it for security, consistency of data with the database, and to generate correct evaluation results.
Select the Capture Files option, if desired, then select a capture directory.
When you select this option, the contents of the directory is masked. The capture file masking is executed consistently with the database.
In the Detect SQL Plan Changes Due to Masking section, leave the Run SQL Performance Analyzer option unchecked.
You do not need to enable this option because the pre- and post-masking scripts you created, referenced in step 2, already execute the analyzer.
Provide credentials and scheduling information, then click Submit.
The Data Masking Definitions page reappears, and a message appears stating that the Data Masking job has been submitted successfully.
During masking of any database, the AWR bind variable data is purged to protect sensitive bind variables from leaking to a test system.
When the job completes successfully, click the link in the SQL Performance Analyzer Task column to view the executed analysis tasks and Trial Comparison Report, which shows any changes in plans, timing, and so forth.