Index

A C D H I M P R S U W

A

application database administrator, role of in data masking, 13.1.3

C

cloning

production database in data masking, 13.4

creating

masking definition, 13.2

D

data masking

Add Columns page, 13.6

Add Dependent Columns page, 13.6.2

adding columns to a masking definition, 13.5

application database administrator, role of, 13.1.3

Canadian social insurance numbers, 13.5.2.2.5

cloning the production database, 13.4, 13.6.3

Create Masking Definition page, 13.6

creating masking definition, 13.2

Data Masking Definitions page, 13.6

Define Column Mask page, 13.5.4

defining new formats, 13.5

description, 13.1.1

DM_FMTLIB package, installing, 13.5.2.3

information security administrator, role of, 13.1.3

ISBN numbers, 13.5.2.2.3

major task steps, 13.4

mask format libraries, description of, 13.2

masking definitions, description of, 13.2

masking format templates, using, 13.5.1.2

North American phone numbers, 13.5.2.2.6

other Oracle security products, 13.1.4

patterns of format definitions, 13.5.2.1

post-processing functions, 13.5.1.1

primary key, 13.2

Script Generation Results page, 13.6

security administrator, 13.3

social security numbers, 13.5.2.2.2

staging region, 13.3

UPC numbers, 13.5.2.2.4

user-defined functions, 13.5.1.1

workflow, 13.3

data, hiding with data masking, 13.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

H

hiding data using data masking, 13.1.1

I

information security administrator, role of in data masking, 13.1.3

M

mapping table

about, 7.1.2

creating, 7.1, 7.1.2

moving, 7.1, 7.1.2

mask format libraries, 13.2

masking definitions, 13.2

credit card numbers, 13.5.2.2.1

P

post-processing functions, data masking and, 13.5.1.1

primary key, data masking and, 13.2

R

Real Application Testing

about, 1

components, 1

regulatory compliance using masked data, 13.1.2

Right to Financial Privacy Act of 1978, 13.1.2

S

Sarbanes-Oxley requirements, 13.1.2

security

compliance with masked data, 13.1.2

data masking, 13.1.1

list of Oracle products, 13.1.4

mask format libraries, 13.2

masking definitions, 13.2

security administrator, data masking and, 13.3

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, 13.3

U

upgrade environment, 7.1, 7.2

user-defined

functions, data masking and, 13.5.1.1

W

Workload Analyzer

about, 10.2.1

running, 10.2.1, 10.2.1