Oracle 12c DBMS_RAT

Oracle DBMS_RAT_MASK Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

Undocumented package supporting data masking with workload captures and replays.

AUTHID

DEFINER

Dependencies

DBA_WORKLOAD_CAPTURES	DBMS_WRR_INTERNAL	WRH$_SQL_PLAN
DBMS_SQLTUNE_LIB	DUAL	WRI$_MASKING_SCRIPT_PROGRESS
DBMS_STANDARD	PRVT_SMGUTIL	WRR$_CAPTURES
DBMS_SYS_ERROR	V$DATABASE	WRR$_REPLAYS
DBMS_WORKLOAD_CAPTURE	WRH$_SQLSTAT	XMLTYPE
DBMS_WORKLOAD_REPLAY

Documented

First Available

12.1.0

Security Model

Owned by SYS with EXECUTE granted to the DBA role

Source

{ORACLE_HOME}/rdbms/admin/dbmsratmask.sql

Subprograms

AWR_PURGE_BINDS	DBR_MASK_DATA	REMOVE_SPA_PEEKED_BINDS
CLEANUP_MASKING	GET_RAT_VERSION	SPA_EXTRACT_DATA
DBR_EXTRACT_DATA	INITIALIZE_MASKING	SPA_MASK_DATA

AWR_PURGE_BINDS

Runs an update statement to delete peeked binds from the other_xml of the AWR plans table

dbms_rat_mask.awr_purge_binds;

exec dbms_rat_mask.awr_purge_binds;

CLEANUP_MASKING

Removes data from all catalog tables related to the script id

dbms_rat_mask.cleanup_masking(script_id IN NUMBER);

TBD

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.dbr_extract_data(
capture_directory IN VARCHAR2,
script_id IN NUMBER);

TBD

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.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;

SELECT dbms_rat_mask.get_rat_version
FROM dual;

INITIALIZE_MASKING

Initialize a rat masking run

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

TBD

REMOVE_SPA_PEEKED_BINDS

Removes peeked binds from the advisor plans table

dbms_rat_mask.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.spa_mask_data(spa_mask_data(script_id IN NUMBER);

TBD