Oracle DBMS_RAT_MASK
Version 19.3

General Information
Library Note Morgan's Library Page Header
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.
AUTHID CURRENT_USER
Dependencies
DBMS_RAT_MASK_INTERNAL XMLTYPE  
Documented No
First Available 12.1.0
Security Model Owned by SYS with no privileges granted.

The package is further protected with ACCESSIBLE BY (SYS.dbms_rat_mask) so no demo code can be executed.
Source {ORACLE_HOME}/rdbms/admin/dbmsratmask.sql
Subprograms
 
I_AWR_PURGE_BINDS
Runs an update statement to delete peeked binds from the other_xml of the AWR plans table dbms_rat_mask.i_awr_purge_binds;
TBD
 
I_CLEANUP_MASKING
Removes data from all catalog tables related to the script id dbms_rat_mask.i_cleanup_masking(script_id IN NUMBER);
TBD
 
I_DBR_EXTRACT_DATA
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.i_dbr_extract_data(
capture_directory IN VARCHAR2,
script_id         IN NUMBER);
TBD
 
I_DBR_MASK_DATA
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.i_dbr_mask_data(
capture_directory IN VARCHAR2,
script_id         IN NUMBER);
TBD
 
GET_RAT_VERSION
Returns the version of kernel code of RAT masking dbms_rat_mask.get_rat_version RETURN NUMBER;
TBD
 
INITIALIZE_MASKING
Initialize a rat masking run dbms_rat_mask.i_initialize_masking(
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
TBD
 
REMOVE_SPA_PEEKED_BINDS
Removes peeked binds from the advisor plans table dbms_rat_mask.i_remove_spa_peeked_binds(task_id IN NUMBER);
TBD
 
SPA_EXTRACT_DATA
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);
TBD
 
SPA_MASK_DATA
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.i_spa_mask_data(spa_mask_data(script_id IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_RAT_MASK
DBMS_REDACT
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_REPLAY
What's New In 18cR3
What's New In 19cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
DBSecWorx