Index

A C D E H I M O P R S U V W

A

Application Data Model (ADM)
- application tables, viewing and editing [1]
- associating a database to [1] , [2]
- creating
  - prerequisites for [1]
- definition of [1]
- discovering sensitive columns [1] , [2]
- editing application tables [1]
- manually adding referential relationships [1] , [2]
- relationship to other TDM components [1]
- sensitive columns
  - automatically discovering [1]
  - changing the type for [1]
  - creating a type for [1]
  - manually adding [1]
- source database status [1]
- upgrading [1]
- verifying source database [1]
- viewing application tables [1]
- viewing referential relationships [1]

C

capture subset
- about [1]
- generating [1]
changing the type for sensitive columns [1]
cloning production database in data masking [1]
Consolidated Database Replay
- about [1]
- connection remapping [1] , [2]
- consolidated replay directory
  - setting [1]
- initializing [1]
- preparing [1]
- replay options [1]
- reporting [1]
- running [1]
- sample scenario [1]
- starting [1]
- steps [1]
- test system
  - capture directory [1]
  - setting up [1]
- user remapping [1] , [2]
- using with APIs [1]
- workload captures
  - supported [1]
creating
- Application Data Model (ADM) [1]
- data masking definition [1]
- data subset definition [1]
- masking definition [1]
- masking formats [1]
- sensitive column type [1]

D

data, hiding with data masking [1]
Database Lifecycle Management Pack [1]
Database Replay
- about [1]
- methodology [1]
- replay clients
  - about [1] , [2]
  - calibrating [1]
  - starting [1] , [2]
- replay filter set
  - about [1]
- reporting
  - replay compare period reports [1] , [2]
  - SQL Performance Analyzer reports [1]
  - workload capture report [1]
  - workload replay report [1]
- usage [1] , [2]
- workflow [1]
- workload capture
  - about [1]
  - capture directory [1]
  - capture files [1]
  - capturing [1] , [2] , [3] , [4]
  - exporting data [1]
  - importing data [1]
  - managing [1]
  - monitoring [1] , [2]
  - options [1]
  - prerequisites [1]
  - reporting [1]
  - restarting the database [1]
  - restrictions [1]
  - stopping [1] , [2]
- workload filters
  - about [1] , [2]
  - defining [1]
  - exclusion filters [1] , [2]
  - inclusion filters [1] , [2]
- workload preprocessing
  - about [1] , [2]
  - preprocessing [1]
- workload replay
  - about [1] , [2]
  - cancelling [1]
  - exporting data [1]
  - filters [1]
  - importing data [1]
  - monitoring [1] , [2]
  - options [1] , [2]
  - pausing [1]
  - replaying [1] , [2]
  - reporting [1]
  - resuming [1]
  - starting [1]
  - steps [1]
database upgrades
- testing [1]
database version
- production system [1] , [2]
- system running SQL Performance Analyzer [1] , [2]
- test system [1] , [2]
data masking
- adding columns to a masking definition [1]
- advanced options [1]
- auto mask [1]
- Canadian social insurance numbers [1]
- cloning and masking [1]
- cloning the production database [1] , [2]
- Create Masking Definition page [1]
- creating formats [1]
- creating masking definition [1] , [2]
- Data Masking Definitions page [1]
- Define Column Mask page [1]
- defining new formats [1]
- dependent columns, adding [1]
- description [1]
- deterministic masking [1]
- DM_FMTLIB package, installing [1]
- encryption seed [1]
- evaluating performance [1]
- format entry options [1]
- importing data masking templates [1]
- ISBN numbers [1]
- major task steps [1]
- mask format libraries, description of [1]
- masking definitions, description of [1]
- masking dependent columns [1]
- masking format templates, using [1]
- masking selected columns as a group [1]
- minimum privileges [1]
- North American phone numbers [1]
- other Oracle security products [1]
- patterns of format definitions [1]
- post-processing functions [1]
- pre- and post-masking scripts [1]
- predefined masking formats [1]
- primary key [1]
- random number generation options [1]
- security administrator [1]
- shuffle format examples [1]
- social security numbers [1]
- staging region [1]
- substitute format [1]
- supported data types [1]
- UK national insurance numbers [1]
- UPC numbers [1]
- upgrading [1]
- using with LONG columns [1]
- workflow [1]
data subsetting
- Ancestor and Descendant Tables [1]
- Ancestor Tables Only [1]
- creating a definition [1]
- exporting subset templates [1]
- generating a subset [1]
- importing subset templates [1]
- providing rules [1]
- required privileges [1] , [2]
- saving a subset script [1]
- space estimates [1]
- specifying Where clause [1]
DBMS_SPM package
- LOAD_PLANS_FROM_SQLSET function [1]
DBMS_SQLPA package
- CREATE_ANALYSIS_TASK function [1]
- EXECUTE_ANALYSIS_TASK procedure [1] , [2] , [3] , [4] , [5]
- REPORT_ANALYSIS_TASK function [1]
- SET_ANALYSIS_TASK_PARAMETER procedure [1] , [2] , [3]
DBMS_SQLTUNE package
- CREATE_TUNING_TASK function [1]
- SELECT_SQL_TRACE function [1]
DBMS_WORKLOAD_CAPTURE package
- ADD_FILTER procedure [1]
- DELETE_FILTER procedure [1]
- EXPORT_AWR procedure [1]
- FINISH_CAPTURE procedure [1]
- GET_CAPTURE_INFO procedure [1]
- IMPORT_AWR function [1]
- START_CAPTURE procedure [1]
DBMS_WORKLOAD_REPLAY package
- ADD_CAPTURE function [1]
- ADD_FILTER procedure [1]
- ADD_SCHEDULE_ORDERING function [1]
- BEGIN_REPLAY_SCHEDULE procedure [1]
- CANCEL_REPLAY procedure [1]
- COMPARE_PERIOD_REPORT procedure [1]
- COMPARE_SQLSET_REPORT procedure [1]
- CREATE_FILTER_SET procedure [1]
- DELETE_FILTER procedure [1]
- DELETE_REPLAY_INFO function [1]
- END_REPLAY_SCHEDULE procedure [1]
- EXPORT_AWR procedure [1]
- GENERATE_CAPTURE_SUBSET procedure [1]
- GET_DIVERGING_STATEMENT function [1]
- GET_REPLAY_DIRECTORY function [1]
- GET_REPLAY_INFO function [1] , [2]
- IMPORT_AWR function [1]
- INITIALIZE_REPLAY procedure [1]
- INITIALIZED_CONSOLIDATED_REPLAY procedure [1]
- LOAD_DIVERGENCE procedure [1]
- PAUSE_REPLAY procedure [1]
- PREPARE_CONSOLIDATED_REPLAY procedure [1]
- PREPARE_REPLAY procedure [1]
- PROCESS_CAPTURE procedure [1]
- REMAP_CONNECTION procedure [1] , [2]
- REMOVE_CAPTURE procedure [1]
- RESUME_REPLAY procedure [1]
- SET_CONSOLIDATED_DIRECTORY procedure [1]
- SET_REPLAY_TIMEOUT procedure [1]
- SET_USER_MAPPING procedure [1] , [2]
- START_CONSOLIDATED_REPLAY procedure [1]
- START_REPLAY procedure [1]
- USE_FILTER_SET procedure [1]
deterministic masking [1]
discovering sensitive columns [1] , [3]

E

editing application tables [1]
exporting
- subset templates, data subsetting [1]

H

hiding data using data masking [1]

I

importing
- data masking templates [1]
- subset templates, data subsetting [1]

M

manually adding sensitive columns [1]
mapping table
- about [1]
- creating [1] , [2]
- moving [1] , [2]
mask format libraries [1]
masking definitions
- credit card numbers [1]
masking formats
- entry options [1]
- predefined [1]

O

Oracle Data Masking and Subsetting Pack [1] , [2] , [3]

P

post-processing functions, data masking [1]
prerequisites for creating an ADM [1]
primary key, data masking and [1]
privileges
- data subsetting [1]
- minimum for data masking [1]

R

Real Application Testing
- about [1]
- components [1]
referential relationships
- manually adding [1] , [2]
- viewing [1]
regulatory compliance using masked data [1]
replay schedule
- about [1]
- defining [1] , [2]
- saving [1]
- schedule orders
  - adding [1]
  - removing [1]
- workload captures
  - adding [1]
  - removing [1]
Right to Financial Privacy Act of 1978 [1]

S

Sarbanes-Oxley regulatory requirements [1]
schedule order
- about [1]
- viewing [1]
Secure Test Data Management [1]
security
- compliance with masked data [1]
- data masking [1]
- list of Oracle products [1]
- mask format libraries [1]
- masking definitions [1]
security administrator, data masking and [1]
sensitive columns
- changing the type for [1]
- creating the type for [1]
- discovering [1] , [2]
- discovering automatically [1]
- manually adding [1]
- performing discovery of [1]
SPA Quick Check
- configuring [1]
- specifying default values [1]
- using [1]
- validating initialization parameter changes [1]
- validating key SQL profiles [1]
- validating pending optimizer statistics [1]
- validating statistics findings [1]
SQL Performance Analyzer
- about [1]
- comparing execution plans [1]
- comparing performance [1] , [2] , [3]
- configuring a task [1]
- creating a task [1] , [2] , [3]
- executing the SQL workload [1] , [2]
- executing the SQL workload after a change [1] , [2]
- initial environment
  - establishing [1]
- input source [1]
- making a change [1]
- methodology [1]
- monitoring [1]
- performance data
  - collecting post-change version [1]
  - collecting pre-change version [1]
  - comparing [1]
- remote test execution [1] , [2]
- reporting [1]
- setting up the test system [1]
- SQL Performance Analyzer report
  - active reports [1]
  - general information [1] , [2]
  - global statistics [1]
  - global statistics details [1]
  - result details [1]
  - result summary [1]
  - reviewing [1] , [2]
- SQL tuning set
  - selecting [1] , [2]
- SQL workload
  - capturing [1]
  - executing [1] , [2]
  - transporting [1]
- system change
  - making [1]
- task
  - creating [1] , [2]
- usage [1]
- using [1]
- workflow
  - Exadata simulation [1]
  - guided [1]
  - optimizer statistics [1]
  - parameter change [1]
SQL Performance Analyzer Quick Check
- See: SPA Quick Check
SQL plan baselines
- creating [1]
SQL statements
- regressed [1] , [2] , [3] , [4] , [5] , [6] , [7] , [8]
SQL Trace
- about [1]
- enabling [1] , [2]
- trace level [1]
SQL trace files
- about [1]
- moving [1] , [2]
SQL trials
- about [1] , [2]
- building
  - post-upgrade version [1] , [2] , [3]
  - pre-upgrade version [1] , [2] , [3] , [4]
- comparing [1]
SQL tuning set
- about [1]
- building [1]
- comparing [1]
- constructing [1]
- converting [1]
staging region, data masking and [1]
statuses for Source Database Status column, ADM [1]
substitute format, data masking and [1]
supported data types, data masking [1]

U

upgrade environment [1] , [2]
upgrading
- ADM [1]
- data masking [1]

V

verifying source database, ADM [1]
viewing
- application tables [1]
- referential relationships [1]

W

Where clause, specifying for data subsetting [1]
Workload Analyzer
- about [1]
- running [1]
Workload Intelligence
- about [1] , [2]
- BuildModel program
  - options [1]
  - syntax [1]
- creating a database user [1]
- creating a job [1]
- creating a workload model [1]
- FindPatterns program
  - about [1]
  - options [1]
  - syntax [1]
- GenerateReport program
  - about [1]
  - options [1]
  - syntax [1]
- generating report [1]
- identifying patterns [1]
- LoadInfo program
  - about [1]
  - options [1]
  - syntax [1]
- pattern [1]
- sample scenario [1]
- template [1]
- using [1]