Index

D M R S U W

D

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

M

mapping table

about, 7.1.2

creating, 7.1, 7.1.2

moving, 7.1, 7.1.2

R

Real Application Testing

about, 1

components, 1

S

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

U

upgrade environment, 7.1, 7.2

W

Workload Analyzer

about, 10.2.1

running, 10.2.1, 10.2.1