Index

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

A

Application Data Model (ADM)

application tables, viewing and editing, 14.1

associating a database to, 14.2, 14.3

creating, 14.1

prerequisites for, 14.1

definition of, 14

discovering sensitive columns, 14.1, 16.6.2, 16.6.2

editing application tables, 14.1

exporting, 14.4

importing, 14.4

manually adding referential relationships, 14.1, 16.6.2

relationship to other DDM components, 14

sensitive columns

automatically discovering, 14.1

changing the type for, 14.1

creating a type for, 14.2

manually adding, 14.1

source database status, 14.5

upgrading, 14.5

verifying source database, 14.5

viewing application tables, 14.1

viewing referential relationships, 14.1

application database administrator, role of in data masking, 16.1.3

C

capture subset

about, 13.2.1.2

generating, 13.3.1

changing the type for sensitive columns, 14.1

cloning production database in data masking, 16.4

Consolidated Database Replay

about, 13

connection remapping, 13.2.4.2, 13.3.4.2

initializing, 13.3.4.1

preparing, 13.3.4.4

replay directory

setting, 13.3.2

replay options, 13.2.4.4

reporting, 13.2.5

running, 13.3.4

starting, 13.3.4.5

steps, 13.2

test system

capture directory, 13.2.2

setting up, 13.2.2

user remapping, 13.2.4.3, 13.3.4.3

using with APIs, 13.3

workload captures

supported, 13.2.1.1

creating

Application Data Model (ADM), 14.1

data masking definition, 16.6

data subset definition, 15.1

masking definition, 16.2

masking formats, 16.5.1

sensitive column type, 14.2

D

Data Discovery and Modeling (DDM), 14

data masking

Add Columns page, 16.6

adding columns to a masking definition, 16.5

advanced options, 16.6.3.1

application database administrator, role of, 16.1.3

Canadian social insurance numbers, 16.5.2.2.5

cloning and masking, 16.7.2

cloning the production database, 16.4, 16.6.4

Create Masking Definition page, 16.6

creating formats, 16.5.1

creating masking definition, 16.2, 16.6

Data Masking Definitions page, 16.6

Define Column Mask page, 16.5.4

defining new formats, 16.5

dependent columns, adding, 16.6.1

description, 16.1.1

deterministic masking, 16.5.4

DM_FMTLIB package, installing, 16.5.2.3

encryption seed, 16.7.1

evaluating performance, 16.7

format entry options, 16.5.3

importing data masking templates, 16.6.5

information security administrator, role of, 16.1.3

ISBN numbers, 16.5.2.2.3

major task steps, 16.4

mask format libraries, description of, 16.2

masking definitions, description of, 16.2

masking dependent columns, 16.6.2

masking format templates, using, 16.5.1.2

masking selected columns as a group, 16.6

minimum privileges, 16.6

North American phone numbers, 16.5.2.2.6

other Oracle security products, 16.1.4

patterns of format definitions, 16.5.2.1

post-processing functions, 16.5.1.1

pre- and post-masking scripts, 16.6.3.3

predefined masking formats, 16.5.2

primary key, 16.2

random number generation options, 16.6.3.2

Script Generation Results page, 16.6

security administrator, 16.3

shuffle format examples, 16.9

social security numbers, 16.5.2.2.2

staging region, 16.3

substitute format, 16.5.4

supported data types, 16.1.6

UPC numbers, 16.5.2.2.4

upgrading, 16.8

user-defined functions, 16.5.1.1

using with LONG columns, 16.10

workflow, 16.3

working around Mask Data step limitation, 16.6.4

data subsetting

Ancestor and Descendant Tables, 15.1

Ancestor Tables Only, 15.1

creating a definition, 15.1

exporting subset templates, 15.3

generating a subset, 15.1

importing subset templates, 15.3

providing rules, 15.1

required privileges, 15.1, 15.4

space estimates, 15.1

specifying Where clause, 15.1

data, hiding with data masking, 16.1.1

Database Replay

about, 1.2

methodology, 8

replay clients

about, 8.3, 11.1.8

calibrating, 11.1.8.1

starting, 11.1.8, 11.1.8.2

replay filter set

about, 11.1.7

reporting, 8.4, 12

compare period reports, 12.3, 12.3.2

usage, 1.2, 8

workflow, 8

workload capture

about, 9

capture directory, 9.2.3

capture files, 8.1

capturing, 8.1, 9.5, 9.7, 9.7.2

exporting data, 9.7.4

managing, 9.6.3

monitoring, 9.6, 9.8

options, 9.2

prerequisites, 9.1

reporting, 12.1

restarting the database, 9.2.1

restrictions, 9.3

stopping, 9.6.2, 9.7.3

workload filters

about, 9.2.2, 11.1.7

defining, 9.7.1

exclusion filters, 9.2.2, 11.1.7

inclusion filters, 9.2.2, 11.1.7

workload preprocessing

about, 8.2, 10

preprocessing, 10.1, 10.2

workload replay

about, 8.3, 11

cancelling, 11.4.9

exporting data, 11.4.10

filters, 11.4.4

monitoring, 11.3, 11.5

options, 11.1.6, 11.4.3

pausing, 11.4.7

replaying, 11.2, 11.4

reporting, 12.2

resuming, 11.4.8

starting, 11.4.6

steps, 11.1

database upgrades

testing, 7

database version

production system, 7.1, 7.2

system running SQL Performance Analyzer, 7.1, 7.2

test system, 7.1, 7.2

DBMS_SPM package

LOAD_PLANS_FROM_SQLSET function, 6.2.6

DBMS_SQLPA package

CREATE_ANALYSIS_TASK function, 3.2

EXECUTE_ANALYSIS_TASK procedure, 4.2, 5.2, 6.2.1, 7.1.4.2, 7.2.1.2

REPORT_ANALYSIS_TASK function, 6.2.1

SET_ANALYSIS_TASK_PARAMETER procedure, 3.2.1

DBMS_SQLTUNE package

CREATE_TUNING_TASK function, 6.2.4

SELECT_SQL_TRACE function, 7.1.3

DBMS_WORKLOAD_CAPTURE package

ADD_FILTER procedure, 9.7.1

DELETE_FILTER procedure, 9.7.1

EXPORT_AWR procedure, 9.7.4

FINISH_CAPTURE procedure, 9.7.3

GET_CAPTURE_INFO procedure, 12.1.2

REPORT function, 12.1.2

START_CAPTURE procedure, 9.7.2

DBMS_WORKLOAD_REPLAY package

ADD_CAPTURE function, 13.3.3.2

ADD_FILTER procedure, 11.4.4.1

ADD_SCHEDULE_ORDERING function, 13.3.3.3

BEGIN_REPLAY_SCHEDULE procedure, 13.3.3.1

CANCEL_REPLAY procedure, 11.4.9

COMPARE_PERIOD_REPORT procedure, 12.3.2.1

COMPARE_SQLSET_REPORT procedure, 12.3.2.2

CREATE_FILTER_SET procedure, 11.4.4.3

DELETE_FILTER procedure, 11.4.4.2

END_REPLAY_SCHEDULE procedure, 13.3.3.4

EXPORT_AWR procedure, 11.4.10

GENERATE_CAPTURE_SUBSET procedure, 13.3.1

GET_DIVERGING_STATEMENT function, 11.5.1

GET_REPLAY_DIRECTORY function, 13.3.2

GET_REPLAY_INFO procedure, 12.2.2

INITIALIZE_REPLAY procedure, 11.4.1

INITIALIZED_CONSOLIDATED_REPLAY procedure, 13.3.4.1

PAUSE_REPLAY procedure, 11.4.7

PREPARE_CONSOLIDATED_REPLAY procedure, 13.3.4.4

PREPARE_REPLAY procedure, 11.4.3

PROCESS_CAPTURE procedure, 10.2

REMAP_CONNECTION procedure, 11.4.2, 13.3.4.2

REMOVE_CAPTURE procedure, 13.3.3.2

REPORT function, 12.2.2

RESUME_REPLAY procedure, 11.4.8

SET_REPLAY_DIRECTORY procedure, 13.3.2

SET_REPLAY_TIMEOUT procedure, 11.4.5

SET_USER_MAPPING procedure, 13.3.4.3

START_CONSOLIDATED_REPLAY procedure, 13.3.4.5

START_REPLAY procedure, 11.4.6

USE_FILTER_SET procedure, 11.4.4.4

deterministic masking, 16.5.4

discovering sensitive columns, 14.1, 14.1, 16.6.2

E

editing application tables, 14.1

exporting

ADM, 14.4

subset templates, data subsetting, 15.3

H

hiding data using data masking, 16.1.1

I

importing

ADM, 14.4

data masking templates, 16.6.5

subset templates, data subsetting, 15.3

information security administrator, role of in data masking, 16.1.3

M

manually adding sensitive columns, 14.1

mapping table

about, 7.1.2

creating, 7.1, 7.1.2

moving, 7.1, 7.1.2

mask format libraries, 16.2

masking definitions, 16.2

credit card numbers, 16.5.2.2.1

masking formats

entry options, 16.5.3

predefined, 16.5.2

P

post-processing functions, data masking, 16.5.1.1

prerequisites for creating an ADM, 14.1

primary key, data masking and, 16.2

privileges

data subsetting, 15.1

minimum for data masking, 16.6

R

Real Application Testing

about, 1

components, 1

referential relationships

manually adding, 14.1, 16.6.2

viewing, 14.1

regulatory compliance using masked data, 16.1.2

replay schedule

about, 13.2.4.1

defining, 13.3.3, 13.3.3.1

saving, 13.3.3.4

schedule orders

adding, 13.3.3.3

removing, 13.3.3.3

workload captures

adding, 13.3.3.2

removing, 13.3.3.2

Right to Financial Privacy Act of 1978, 16.1.2

S

Sarbanes-Oxley regulatory requirements, 16.1.2

schedule order

about, 13.2.4.1.2

viewing, 13.3.3.3

Secure Test Data Management, 14

security

compliance with masked data, 16.1.2

data masking, 16.1.1

list of Oracle products, 16.1.4

mask format libraries, 16.2

masking definitions, 16.2

security administrator, data masking and, 16.3

sensitive columns

changing the type for, 14.1

creating the type for, 14.2

discovering, 14.1, 16.6.2

discovering automatically, 14.1

manually adding, 14.1

performing discovery of, 16.6.2

SQL Performance Analyzer

about, 1.1

comparing performance, 6.2.1, 7.1, 7.2

creating a task, 3, 3.1, 3.2

executing the SQL workload, 4.1, 4.2

executing the SQL workload after a change, 5.1, 5.2

initial environment

establishing, 4

input source, 7.1

making a change, 5

methodology, 2

monitoring, 6.2.7

performance data

collecting post-change version, 5

collecting pre-change version, 4

comparing, 6

remote test execution, 7.1.4, 7.2.1, 7.2.1

reporting, 2.7

setting up the test system, 2.2

SQL Performance Analyzer report

active reports, 6.1.2.4

general information, 6.1.2.1, 6.2.2.1

global statistics, 6.1.2.2

global statistics details, 6.1.2.3

result details, 6.2.2.3

result summary, 6.2.2.2

reviewing, 6.1.2, 6.2.2

SQL tuning set

selecting, 2.3, 3

SQL workload

capturing, 2.1

executing, 2.4, 2.6

transporting, 2.2

system change

making, 5

task

creating, 7.1, 7.2

usage, 1.1

using, 2

workflow, 2

Exadata simulation, 3.1.3

guided, 3.1.4

optimizer statistics, 3.1.2

parameter change, 3.1.1

SQL plan baselines

creating, 6.2.6

SQL statements

regressed, 1.1, 2.8, 6.1.3, 6.2.4, 6.2.5, 7.1, 7.2, 7.3

SQL Trace

about, 7.1.1

enabling, 7.1, 7.1.1

trace level, 7.1.1

SQL trace files

about, 7.1.1

moving, 7.1, 7.1.1

SQL trials

about, 2.3, 2.4

building

post-upgrade version, 7.1, 7.1.4, 7.2

pre-upgrade version, 7.1, 7.1.4.2, 7.2, 7.2.1.2

comparing, 6.1

SQL tuning set

about, 2.1

building, 7.1.3

comparing, 6.2.3

constructing, 7.1

converting, 7.1, 7.1.4.2

staging region, data masking and, 16.3

statuses for Source Database Status column, ADM, 14.5

substitute format, data masking and, 16.5.4

supported data types, data masking, 16.1.6

U

upgrade environment, 7.1, 7.2

upgrading

ADM, 14.5

data masking, 16.8

user-defined functions, data masking and, 16.5.1.1

V

verifying source database, ADM, 14.5

viewing

application tables, 14.1

referential relationships, 14.1

W

Where clause, specifying for data subsetting, 15.1

Workload Analyzer

about, 10.2.1

running, 10.2.1, 10.2.1