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_CONSOLIDATED_REPLAY procedure 1
- INITIALIZE_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