For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
Purpose
Undocumented package supporting data masking with workload captures and replays.
API for the extract phase of rat masking for capture files. It makes a call out to the kernel function which iterates over each statement in each capture file and extracts all sensitive bind values.
dbms_rat_mask.dbr_extract_data(
capture_directory IN VARCHAR2,
script_id IN NUMBER);
API for the mask phase of rat masking for capture files. It makes a call out to the kernel function which iterates over each stmt in each cap file and replaces the values of all sensitive binds with masked values. It also removes binds in AWR.
dbms_rat_mask.dbr_mask_data(
capture_directory IN VARCHAR2,
script_id IN NUMBER);
dbms_rat_mask.initialize(
user_name IN VARCHAR2, -- user executing the masking script
package_name IN VARCHAR2, -- name of masking package
mask_definition IN XMLTYPE, -- xml of masking definition
control_xml IN XMLTYPE DEFAULT NULL); -- control xml from masking definition
API for the extract phase of rat masking for SQL tuning sets. It makes a call out to the kernel function which iterates over each statement in each STS in the db and extracts all sensitive bind values.
dbms_rat_mask.spa_extract_data(spa_extract_data(script_id IN NUMBER);
API for the mask phase of rat masking for SQL tuning sets.
It makes a call out to the kernel function which iterates over each stmt in each STS in the db and replaces the values of all sensitive binds with masked values. It also removes peeked binds present in the other_xml column of the plan lines table.
dbms_rat_mask.spa_mask_data(spa_mask_data(script_id IN NUMBER);