Index

D  E  M  R  S  U  W 

---

D

Database Replay

about, 1.1

methodology, 2

reporting, 2.4

usage, 1.1

using, 2

workflow, 2

workload capture, 2.1, 3

workload preprocessing, 2.2

workload replay, 2.3

database version

production system, 12.1, 12.2

system running SQL Performance Analyzer, 12.1, 12.2

test system, 12.1, 12.2

---

E

EXECUTE_ANALYSIS_TASK procedure, 12.1.4.2, 12.1.4.2, 12.2.1.2, 12.2.1.2

---

M

mapping table

about, 12.1.2

creating, 12.1, 12.1.2

moving, 12.1, 12.1.2

---

R

regressed SQL

tuning, 11.1.3, 11.2.4, 12.1, 12.2

replay filter set

about, 5.2.5

---

S

SELECT_SQL_TRACE function

parameters, 12.1.3

syntax, 12.1.3

using, 12.1.3

SQL performance

comparing, 12.1, 12.2

SQL Performance Analyzer

about, 1.2

comparing SQL performance, 11.2.1

creating a task, 8.2

executing the SQL workload, 9.2

executing the SQL workload after a change, 10.2

following guided workflow, 8.1.3

initial environment

establishing, 9

input source, 12.1

making a change, 10

methodology, 7

monitoring, 11.2.7

performance data

collecting post-change version, 10

collecting pre-change version, 9

comparing, 11

remote test execution, 12.1.4, 12.2.1, 12.2.1

setting up the test system, 7.2

SQL Performance Analyzer report

general information, 11.1.2.1, 11.2.2.1

global statistics, 11.1.2.2

global statistics details, 11.1.2.3

result details, 11.2.2.3

result summary, 11.2.2.2

reviewing, 11.1.2, 11.2.2

SQL tuning set

selecting, 7.3, 8

SQL workload

capturing, 7.1

executing, 7.4

transporting, 7.2

system change

making, 10

task

creating, 12.1, 12.2

usage, 1.2

using, 7

workflow, 7

Exadata simulation, 8.1.2

guided, 8.1.3

parameter change, 8.1.1

SQL statements

regressed, 1.2

SQL Trace

about, 12.1.1

enabling, 12.1, 12.1.1

trace level, 12.1.1

SQL trace files

about, 12.1.1

moving, 12.1, 12.1.1

SQL trial

about, 7.3, 7.4

building

post-upgrade version, 12.1, 12.1.4, 12.2, 12.2.1

pre-upgrade version, 12.1, 12.1.4.2, 12.2, 12.2.1, 12.2.1.2

SQL tuning set

about, 7.1

building, 12.1.3

constructing, 12.1

converting, 12.1

using APIs, 12.1.4.2

---

U

upgrade environment, 12.1, 12.2

---

W

workload capture

about, 2.1

capture directory, 3.2.3

capture files, 2.1

options, 3.2

prerequisites, 3.1

restarting the database, 3.2.1

restrictions, 3.3

workload filters, 3.2.2

workload filters

about, 3.2.2, 5.2.5

exclusion filters, 3.2.2, 5.2.5

inclusion filters, 3.2.2, 5.2.5

workload preprocessing

about, 2.2

workload replay

about, 2.3

replay client, 2.3

workload filters, 5.2.5