Skip Headers
Oracle® Database Testing Guide
12c Release 1 (12.1)

E20852-17
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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, 16.1
associating a database to, 16.2, 16.3
creating, 16.1
prerequisites for, 16.1
definition of, 16
discovering sensitive columns, 16.1, 18.6.6, 18.6.6
editing application tables, 16.1
manually adding referential relationships, 16.1, 18.6.6
relationship to other TDM components, 16
sensitive columns
automatically discovering, 16.1
changing the type for, 16.1
creating a type for, 16.2
manually adding, 16.1
source database status, 16.5
upgrading, 16.5
verifying source database, 16.5
viewing application tables, 16.1
viewing referential relationships, 16.1
application database administrator, role of in data masking, 18.1.3

C

capture subset
about, 14.2.1.2
generating, 14.4.1
changing the type for sensitive columns, 16.1
cloning production database in data masking, 18.4
Consolidated Database Replay
about, 14
connection remapping, 14.2.4.2, 14.4.4.2
initializing, 14.4.4.1
preparing, 14.4.4.4
replay directory
setting, 14.4.2
replay options, 14.2.4.4
reporting, 14.2.5
running, 14.4.4
sample scenario, 14.5
starting, 14.4.4.5
steps, 14.2
test system
capture directory, 14.2.2
setting up, 14.2.2
user remapping, 14.2.4.3, 14.4.4.3
using with APIs, 14.4
workload captures
supported, 14.2.1.1
creating
Application Data Model (ADM), 16.1
data masking definition, 18.6
data subset definition, 17.1
masking definition, 18.2
masking formats, 18.5.1
sensitive column type, 16.2

D

Data Discovery and Modeling, 16
data masking
adding columns to a masking definition, 18.5
advanced options, 18.6.2.1
application database administrator, role of, 18.1.3
auto mask, 18.5.2.2.8
Canadian social insurance numbers, 18.5.2.2.5
cloning and masking, 18.7.2
cloning the production database, 18.4, 18.6.7
Create Masking Definition page, 18.6
creating formats, 18.5.1
creating masking definition, 18.2, 18.6
Data Masking Definitions page, 18.6
Define Column Mask page, 18.5.4
defining new formats, 18.5
dependent columns, adding, 18.6.5
description, 18.1.1
deterministic masking, 18.5.4
DM_FMTLIB package, installing, 18.5.2.3
encryption seed, 18.7.1
evaluating performance, 18.7
format entry options, 18.5.3
importing data masking templates, 18.6.8
information security administrator, role of, 18.1.3
ISBN numbers, 18.5.2.2.3
major task steps, 18.4
mask format libraries, description of, 18.2
masking definitions, description of, 18.2
masking dependent columns, 18.6.6
masking format templates, using, 18.5.1.2
masking selected columns as a group, 18.6.1
minimum privileges, 18.6
North American phone numbers, 18.5.2.2.6
other Oracle security products, 18.1.4
patterns of format definitions, 18.5.2.1
post-processing functions, 18.5.1.1
pre- and post-masking scripts, 18.6.2.3
predefined masking formats, 18.5.2
primary key, 18.2
random number generation options, 18.6.2.2
security administrator, 18.3
shuffle format examples, 18.9
social security numbers, 18.5.2.2.2
staging region, 18.3
substitute format, 18.5.4
supported data types, 18.1.6
UK national insurance numbers, 18.5.2.2.7
UPC numbers, 18.5.2.2.4
upgrading, 18.8
user-defined functions, 18.5.1.1
using with LONG columns, 18.12
workflow, 18.3
data subsetting
Ancestor and Descendant Tables, 17.1
Ancestor Tables Only, 17.1
creating a definition, 17.1
exporting subset templates, 17.2.2
generating a subset, 17.1.1
importing subset templates, 17.2.1
providing rules, 17.1
required privileges, 17.1, 17.3
saving a subset script, 17.1.2
space estimates, 17.1
specifying Where clause, 17.1
data, hiding with data masking, 18.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
replay compare period reports, 12.3, 12.3.1
SQL Performance Analyzer reports, 12.4
usage, 1.2, 8
workflow, 8
workload capture
about, 9
capture directory, 9.2
capture files, 8.1
capturing, 8.1, 9.7, 9.13, 9.13.2
exporting data, 9.13.4
importing data, 9.13.5
managing, 9.9.3
monitoring, 9.9, 9.14
options, 9.3
prerequisites, 9.1
reporting, 12.1
restarting the database, 9.3.1
restrictions, 9.4
stopping, 9.9.2, 9.13.3
workload filters
about, 9.3.2, 11.1.7
defining, 9.13.1
exclusion filters, 9.3.2, 11.1.7
inclusion filters, 9.3.2, 11.1.7
workload preprocessing
about, 8.2, 10
preprocessing, 10.2
workload replay
about, 8.3, 11
cancelling, 11.6.10
exporting data, 11.6.11
filters, 11.6.5
importing data, 11.6.12
monitoring, 11.4, 11.7
options, 11.1.6, 11.6.4
pausing, 11.6.8
replaying, 11.2, 11.6
reporting, 12.2
resuming, 11.6.9
starting, 11.6.7
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, 3.3
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.13.1
DELETE_FILTER procedure, 9.13.1
EXPORT_AWR procedure, 9.13.4
FINISH_CAPTURE procedure, 9.13.3
GET_CAPTURE_INFO procedure, 12.1.2
IMPORT_AWR function, 9.13.5
REPORT function, 12.1.2
START_CAPTURE procedure, 9.13.2
DBMS_WORKLOAD_REPLAY package
ADD_CAPTURE function, 14.4.3.2
ADD_FILTER procedure, 11.6.5.1
ADD_SCHEDULE_ORDERING function, 14.4.3.3
BEGIN_REPLAY_SCHEDULE procedure, 14.4.3.1
CANCEL_REPLAY procedure, 11.6.10
COMPARE_PERIOD_REPORT procedure, 12.3.1
COMPARE_SQLSET_REPORT procedure, 12.4.1
CREATE_FILTER_SET procedure, 11.6.5.3
DELETE_FILTER procedure, 11.6.5.2
END_REPLAY_SCHEDULE procedure, 14.4.3.4
EXPORT_AWR procedure, 11.6.11
GENERATE_CAPTURE_SUBSET procedure, 14.4.1
GET_DIVERGING_STATEMENT function, 11.7.1
GET_REPLAY_DIRECTORY function, 14.4.2
GET_REPLAY_INFO procedure, 12.2.2
IMPORT_AWR function, 11.6.12
INITIALIZE_REPLAY procedure, 11.6.1
INITIALIZED_CONSOLIDATED_REPLAY procedure, 14.4.4.1
PAUSE_REPLAY procedure, 11.6.8
PREPARE_CONSOLIDATED_REPLAY procedure, 14.4.4.4
PREPARE_REPLAY procedure, 11.6.4
PROCESS_CAPTURE procedure, 10.2
REMAP_CONNECTION procedure, 11.6.2, 14.4.4.2
REMOVE_CAPTURE procedure, 14.4.3.2
REPORT function, 12.2.2
RESUME_REPLAY procedure, 11.6.9
SET_REPLAY_DIRECTORY procedure, 14.4.2
SET_REPLAY_TIMEOUT procedure, 11.6.6
SET_USER_MAPPING procedure, 11.6.3, 14.4.4.3
START_CONSOLIDATED_REPLAY procedure, 14.4.4.5
START_REPLAY procedure, 11.6.7
USE_FILTER_SET procedure, 11.6.5.4
deterministic masking, 18.5.4
discovering sensitive columns, 16.1, 16.1, 18.6.6

E

editing application tables, 16.1
exporting
subset templates, data subsetting, 17.2.2

H

hiding data using data masking, 18.1.1

I

importing
data masking templates, 18.6.8
subset templates, data subsetting, 17.2.1
information security administrator, role of in data masking, 18.1.3

M

manually adding sensitive columns, 16.1
mapping table
about, 7.1.2
creating, 7.1, 7.1.2
moving, 7.1, 7.1.2
mask format libraries, 18.2
masking definitions, 18.2
credit card numbers, 18.5.2.2.1
masking formats
entry options, 18.5.3
predefined, 18.5.2

O

Oracle Data Masking Pack, 16
Oracle Test Data Management Pack, 16

P

post-processing functions, data masking, 18.5.1.1
prerequisites for creating an ADM, 16.1
primary key, data masking and, 18.2
privileges
data subsetting, 17.1
minimum for data masking, 18.6

R

Real Application Testing
about, 1
components, 1
referential relationships
manually adding, 16.1, 18.6.6
viewing, 16.1
regulatory compliance using masked data, 18.1.2
replay schedule
about, 14.2.4.1
defining, 14.4.3, 14.4.3.1
saving, 14.4.3.4
schedule orders
adding, 14.4.3.3
removing, 14.4.3.3
workload captures
adding, 14.4.3.2
removing, 14.4.3.2
Right to Financial Privacy Act of 1978, 18.1.2

S

Sarbanes-Oxley regulatory requirements, 18.1.2
schedule order
about, 14.2.4.1.2
viewing, 14.4.3.3
security
compliance with masked data, 18.1.2
data masking, 18.1.1
list of Oracle products, 18.1.4
mask format libraries, 18.2
masking definitions, 18.2
security administrator, data masking and, 18.3
sensitive columns
changing the type for, 16.1
creating the type for, 16.2
discovering, 16.1, 18.6.6
discovering automatically, 16.1
manually adding, 16.1
performing discovery of, 18.6.6
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
staging region, data masking and, 18.3
statuses for Source Database Status column, ADM, 16.5
substitute format, data masking and, 18.5.4
supported data types, data masking, 18.1.6

U

upgrade environment, 7.1, 7.2
upgrading
ADM, 16.5
data masking, 18.8
user-defined functions, data masking and, 18.5.1.1

V

verifying source database, ADM, 16.5
viewing
application tables, 16.1
referential relationships, 16.1

W

Where clause, specifying for data subsetting, 17.1
Workload Analyzer
about, 10.2.1
running, 10.2.1
Workload Intelligence
about, 13.1, 13.1.1
BuildModel program
about, 13.2.3
options, 13.2.3
syntax, 13.2.3
creating a database user, 13.2.1
creating a job, 13.2.2
creating a workload model, 13.2.3
FindPatterns program
about, 13.2.4
options, 13.2.4
syntax, 13.2.4
GenerateReport program
about, 13.2.5
options, 13.2.5
syntax, 13.2.5
generating report, 13.2.5
identifying patterns, 13.2.4
LoadInfo program
about, 13.2.2
options, 13.2.2
syntax, 13.2.2
pattern, 13.1.1
sample scenario, 13.3
template, 13.1.1
using, 13.2