Index

C D M R S U W

C

capture subset
- about 15.2.1.2
- generating 15.4.1
Consolidated Database Replay
- about 15
- connection remapping 15.2.4.2, 15.4.4.2
- consolidated replay directory
  - setting 15.4.2
- initializing 15.4.4.1
- preparing 15.4.4.4
- replay options 15.2.4.4
- reporting 15.2.5
- running 15.4.4
- sample scenario 15.6
- starting 15.4.4.5
- steps 15.2
- test system
  - capture directory 15.2.2
  - setting up 15.2.2
- user remapping 15.2.4.3, 15.4.4.3
- using with APIs 15.4
- workload captures
  - supported 15.2.1.1

D

Database Replay
- about 1.2
- methodology 9
- replay clients
  - about 9.3, 12.1.8
  - calibrating 12.1.8.1
  - starting 12.1.8, 12.1.8.2
- replay filter set
  - about 12.1.7
- reporting 9.4, 13
  - replay compare period reports 13.3, 13.3.1
  - SQL Performance Analyzer reports 13.4
  - workload capture report 13.1.2
  - workload replay report 13.2.2
- usage 1.2, 9
- workflow 9
- workload capture
  - about 10
  - capture directory 10.2
  - capture files 9.1
  - capturing 9.1, 10.7, 10.13, 10.13.2
  - decrypting 10.14.2
  - encrypting 10.14.1
  - exporting data 10.13.4
  - importing data 10.13.5
  - managing 10.9.3
  - monitoring 10.9, 10.15
  - options 10.3
  - prerequisites 10.1
  - reporting 13.1
  - restarting the database 10.3.1
  - restrictions 10.4
  - stopping 10.9.2, 10.13.3
- workload filters
  - about 10.3.2, 12.1.7
  - defining 10.13.1
  - exclusion filters 10.3.2, 12.1.7
  - inclusion filters 10.3.2, 12.1.7
- workload preprocessing
  - about 9.2, 11
  - preprocessing 11.2
- workload replay
  - about 9.3, 12
  - cancelling 12.6.10
  - exporting data 12.6.14
  - filters 12.6.5
  - importing data 12.6.15
  - monitoring 12.4, 12.7
  - options 12.1.6, 12.6.4
  - pausing 12.6.8
  - replaying 12.2, 12.6
  - reporting 13.2
  - resuming 12.6.9
  - starting 12.6.7
  - steps 12.1
database upgrades
- testing 8
database version
- production system 8.1, 8.2
- system running SQL Performance Analyzer 8.1, 8.2
- test system 8.1, 8.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, 8.1.4.2, 8.2.1.2
- REPORT_ANALYSIS_TASK function 6.2.1
- SET_ANALYSIS_TASK_PARAMETER procedure 3.3.1, 3.3.2, 3.3.3, 3.3.4, 3.3.5, 3.3.6, 3.3.7
DBMS_SQLTUNE package
- CREATE_TUNING_TASK function 6.2.4
- SELECT_SQL_TRACE function 8.1.3
DBMS_WORKLOAD_CAPTURE package
- ADD_FILTER procedure 10.13.1
- DECRYPT_CAPTURE procedure 10.14.2
- DELETE_FILTER procedure 10.13.1
- ENCRYPT_CAPTURE procedure 10.14.1
- EXPORT_AWR procedure 10.13.4
- FINISH_CAPTURE procedure 10.13.3
- GET_CAPTURE_INFO procedure 13.1.2
- IMPORT_AWR function 10.13.5
- START_CAPTURE procedure 10.13.2
DBMS_WORKLOAD_REPLAY package
- ADD_CAPTURE function 15.4.3.2
- ADD_FILTER procedure 12.6.5.1
- ADD_SCHEDULE_ORDERING function 15.4.3.3
- BEGIN_REPLAY_SCHEDULE procedure 15.4.3.1
- CANCEL_REPLAY procedure 12.6.10
- COMPARE_PERIOD_REPORT procedure 13.3.1
- COMPARE_SQLSET_REPORT procedure 13.4.1
- CREATE_FILTER_SET procedure 12.6.5.3
- DELETE_FILTER procedure 12.6.5.2
- DELETE_REPLAY_INFO function 12.6.13
- END_REPLAY_SCHEDULE procedure 15.4.3.4
- EXPORT_AWR procedure 12.6.14
- GENERATE_CAPTURE_SUBSET procedure 15.4.1
- GET_DIVERGING_STATEMENT function 12.7.1
- GET_REPLAY_DIRECTORY function 15.4.2
- GET_REPLAY_INFO function 12.6.11, 13.2.2
- IMPORT_AWR function 12.6.15
- INITIALIZE_CONSOLIDATED_REPLAY procedure 15.4.4.1
- INITIALIZE_REPLAY procedure 12.6.1
- LOAD_DIVERGENCE procedure 12.6.12
- PAUSE_REPLAY procedure 12.6.8
- PREPARE_CONSOLIDATED_REPLAY procedure 15.4.4.4
- PREPARE_REPLAY procedure 12.6.4
- PROCESS_CAPTURE procedure 11.2
- REMAP_CONNECTION procedure 12.6.2, 15.4.4.2
- REMOVE_CAPTURE procedure 15.4.3.2
- RESUME_REPLAY procedure 12.6.9
- SET_CONSOLIDATED_DIRECTORY procedure 15.4.2
- SET_REPLAY_TIMEOUT procedure 12.6.6
- SET_USER_MAPPING procedure 12.6.3, 15.4.4.3
- START_CONSOLIDATED_REPLAY procedure 15.4.4.5
- START_REPLAY procedure 12.6.7
- USE_FILTER_SET procedure 12.6.5.4

M

mapping table
- about 8.1.2
- creating 8.1, 8.1.2
- moving 8.1, 8.1.2

R

Real Application Testing
- about 1
- components 1
replay schedule
- about 15.2.4.1
- defining 15.4.3, 15.4.3.1
- saving 15.4.3.4
- schedule orders
  - adding 15.4.3.3
  - removing 15.4.3.3
- workload captures
  - adding 15.4.3.2
  - removing 15.4.3.2

S

schedule order
- about 15.2.4.1.2
- viewing 15.4.3.3
SPA Quick Check
- configuring 7.1
- specifying default values 7.2
- using 7
- validating initialization parameter changes 7.3
- validating key SQL profiles 7.5
- validating pending optimizer statistics 7.4
- validating statistics findings 7.6
SQL Performance Analyzer
- about 1.1
- comparing execution plans 3.3.1
- comparing performance 6.2.1, 8.1, 8.2
- configuring a date to be returned by calls 3.3.5
- configuring a task 3.3
- configuring degree of parallelism 3.3.7
- configuring the number of rows to fetch 3.3.6
- configuring trigger execution 3.3.4
- 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 8.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 8.1.4, 8.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 result sets
  - validating 3.3.8
- 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 8.1, 8.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 Performance Analyzer Quick Check
- See: SPA Quick Check
SQL plan baselines
- creating 6.2.6
SQL statements
- regressed 1.1, 2.8, 6.1.3, 6.2.4, 6.2.5, 8.1, 8.2, 8.3
SQL Trace
- about 8.1.1
- enabling 8.1, 8.1.1
- trace level 8.1.1
SQL trace files
- about 8.1.1
- moving 8.1, 8.1.1
SQL trials
- about 2.3, 2.4
- building
  - post-upgrade version 8.1, 8.1.4, 8.2
  - pre-upgrade version 8.1, 8.1.4.2, 8.2, 8.2.1.2
- comparing 6.1
SQL tuning set
- about 2.1
- building 8.1.3
- comparing 6.2.3
- constructing 8.1
- converting 8.1

U

upgrade environment 8.1, 8.2

W

Workload Analyzer
- about 11.2.1
- running 11.2.1
Workload Intelligence
- about 14.1, 14.1.1
- BuildModel program
  - options 14.2.3
  - syntax 14.2.3
- creating a database user 14.2.1
- creating a job 14.2.2
- creating a workload model 14.2.3
- FindPatterns program
  - about 14.2.4
  - options 14.2.4
  - syntax 14.2.4
- GenerateReport program
  - about 14.2.5
  - options 14.2.5
  - syntax 14.2.5
- generating report 14.2.5
- identifying patterns 14.2.4
- LoadInfo program
  - about 14.2.2
  - options 14.2.2
  - syntax 14.2.2
- pattern 14.1.1
- sample scenario 14.3
- template 14.1.1
- using 14.2