Index

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

A

Application Data Model (ADM)

application tables, viewing and editing, 13.1

associating a database to, 13.2, 13.3

creating, 13.1

prerequisites for, 13.1

definition of, 13

discovering sensitive columns, 13.1, 15.6.2, 15.6.2

editing application tables, 13.1

exporting, 13.4

importing, 13.4

manually adding referential relationships, 13.1, 15.6.2

relationship to other DDM components, 13

sensitive columns

automatically discovering, 13.1

changing the type for, 13.1

creating a type for, 13.2

manually adding, 13.1

source database status, 13.5

upgrading, 13.5

verifying source database, 13.5

viewing application tables, 13.1

viewing referential relationships, 13.1

application database administrator, role of in data masking, 15.1.3

C

changing the type for sensitive columns, 13.1

cloning production database in data masking, 15.4

creating

Application Data Model (ADM), 13.1

data masking definition, 15.6

data subset definition, 14.1

masking definition, 15.2

masking formats, 15.5.1

sensitive column type, 13.2

D

Data Discovery and Modeling (DDM), 13

data masking

Add Columns page, 15.6

adding columns to a masking definition, 15.5

advanced options, 15.6.3.1

application database administrator, role of, 15.1.3

Canadian social insurance numbers, 15.5.2.2.5

cloning and masking, 15.7.2

cloning the production database, 15.4, 15.6.4

Create Masking Definition page, 15.6

creating formats, 15.5.1

creating masking definition, 15.2, 15.6

Data Masking Definitions page, 15.6

Define Column Mask page, 15.5.4

defining new formats, 15.5

dependent columns, adding, 15.6.1

description, 15.1.1

deterministic masking, 15.5.4

DM_FMTLIB package, installing, 15.5.2.3

encryption seed, 15.7.1

evaluating performance, 15.7

format entry options, 15.5.3

importing data masking templates, 15.6.5

information security administrator, role of, 15.1.3

ISBN numbers, 15.5.2.2.3

major task steps, 15.4

mask format libraries, description of, 15.2

masking definitions, description of, 15.2

masking dependent columns, 15.6.2

masking format templates, using, 15.5.1.2

masking selected columns as a group, 15.6

minimum privileges, 15.6

North American phone numbers, 15.5.2.2.6

other Oracle security products, 15.1.4

patterns of format definitions, 15.5.2.1

post-processing functions, 15.5.1.1

pre- and post-masking scripts, 15.6.3.3

predefined masking formats, 15.5.2

primary key, 15.2

random number generation options, 15.6.3.2

Script Generation Results page, 15.6

security administrator, 15.3

shuffle format examples, 15.9

social security numbers, 15.5.2.2.2

staging region, 15.3

substitute format, 15.5.4

supported data types, 15.1.6

UPC numbers, 15.5.2.2.4

upgrading, 15.8

user-defined functions, 15.5.1.1

using with LONG columns, 15.10

workflow, 15.3

working around Mask Data step limitation, 15.6.4

data subsetting

Ancestor and Descendant Tables, 14.1

Ancestor Tables Only, 14.1

creating a definition, 14.1

exporting subset templates, 14.3

generating a subset, 14.1

importing subset templates, 14.3

providing rules, 14.1

required privileges, 14.1, 14.4

space estimates, 14.1

specifying Where clause, 14.1

data, hiding with data masking, 15.1.1

Database Replay

about, 1.2

methodology, 8

replay clients

about, 8.3, 11.2.6

calibrating, 11.2.6.1

starting, 11.2.6, 11.2.6.2

replay filter set

about, 11.2.5

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

defining, 9.7.1

exclusion filters, 9.2.2, 11.2.5

inclusion filters, 9.2.2, 11.2.5

workload preprocessing

about, 8.2, 10

preprocessing, 10.1, 10.2

workload replay

about, 8.3, 11

cancelling, 11.5.9

exporting data, 11.5.10

filters, 11.5.4

monitoring, 11.4, 11.6

options, 11.2.4, 11.5.3

pausing, 11.5.7

replaying, 11.3, 11.5

reporting, 12.2

resuming, 11.5.8

starting, 11.5.6

steps, 11.2

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_FILTER procedure, 11.5.4.1

CANCEL_REPLAY procedure, 11.5.9

COMPARE_PERIOD_REPORT procedure, 12.3.2.1

COMPARE_SQLSET_REPORT procedure, 12.3.2.2

CREATE_FILTER_SET procedure, 11.5.4.3

DELETE_FILTER procedure, 11.5.4.2

EXPORT_AWR procedure, 11.5.10

GET_DIVERGING_STATEMENT function, 11.6.1

GET_REPLAY_INFO procedure, 12.2.2

INITIALIZE_REPLAY procedure, 11.5.1

PAUSE_REPLAY procedure, 11.5.7

PREPARE_REPLAY procedure, 11.5.3

PROCESS_CAPTURE procedure, 10.2

REMAP_CONNECTION procedure, 11.5.2

REPORT function, 12.2.2

RESUME_REPLAY procedure, 11.5.8

SET_REPLAY_TIMEOUT procedure, 11.5.5

START_REPLAY procedure, 11.5.6

USE_FILTER_SET procedure, 11.5.4.4

deterministic masking, 15.5.4

discovering sensitive columns, 13.1, 13.1, 15.6.2

E

editing application tables, 13.1

exporting

ADM, 13.4

subset templates, data subsetting, 14.3

H

hiding data using data masking, 15.1.1

I

importing

ADM, 13.4

data masking templates, 15.6.5

subset templates, data subsetting, 14.3

information security administrator, role of in data masking, 15.1.3

M

manually adding sensitive columns, 13.1

mapping table

about, 7.1.2

creating, 7.1, 7.1.2

moving, 7.1, 7.1.2

mask format libraries, 15.2

masking definitions, 15.2

credit card numbers, 15.5.2.2.1

masking formats

entry options, 15.5.3

predefined, 15.5.2

P

post-processing functions, data masking, 15.5.1.1

prerequisites for creating an ADM, 13.1

primary key, data masking and, 15.2

privileges

data subsetting, 14.1

minimum for data masking, 15.6

R

Real Application Testing

about, 1

components, 1

referential relationships

manually adding, 13.1, 15.6.2

viewing, 13.1

regulatory compliance using masked data, 15.1.2

Right to Financial Privacy Act of 1978, 15.1.2

S

Sarbanes-Oxley regulatory requirements, 15.1.2

Secure Test Data Management, 13

security

compliance with masked data, 15.1.2

data masking, 15.1.1

list of Oracle products, 15.1.4

mask format libraries, 15.2

masking definitions, 15.2

security administrator, data masking and, 15.3

sensitive columns

changing the type for, 13.1

creating the type for, 13.2

discovering, 13.1, 15.6.2

discovering automatically, 13.1

manually adding, 13.1

performing discovery of, 15.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, 15.3

statuses for Source Database Status column, ADM, 13.5

substitute format, data masking and, 15.5.4

supported data types, data masking, 15.1.6

U

upgrade environment, 7.1, 7.2

upgrading

ADM, 13.5

data masking, 15.8

user-defined functions, data masking and, 15.5.1.1

V

verifying source database, ADM, 13.5

viewing

application tables, 13.1

referential relationships, 13.1

W

Where clause, specifying for data subsetting, 14.1

Workload Analyzer

about, 10.2.1

running, 10.2.1, 10.2.1