Index

C D M R S U W

C

capture subset
- about 1
- generating 1
Consolidated Database Replay
- about 1
- connection remapping 1 , 2
- consolidated replay directory
  - setting 1
- initializing 1
- preparing 1
- replay options 1
- reporting 1
- running 1
- sample scenario 1
- starting 1
- steps 1
- test system
  - capture directory 1
  - setting up 1
- user remapping 1 , 2
- using with APIs 1
- workload captures
  - supported 1

D

Database Replay
- about 1
- methodology 1
- replay clients
  - about 1 , 2
  - calibrating 1
  - starting 1 , 2
- replay filter set
  - about 1
- reporting
  - replay compare period reports 1 , 2
  - SQL Performance Analyzer reports 1
  - workload capture report 1
  - workload replay report 1
- usage 1 , 2
- workflow 1
- workload capture
  - about 1
  - capture directory 1
  - capture files 1
  - capturing 1 , 2 , 3 , 4
  - exporting data 1
  - importing data 1
  - managing 1
  - monitoring 1 , 2
  - options 1
  - prerequisites 1
  - reporting 1
  - restarting the database 1
  - restrictions 1
  - stopping 1 , 2
- workload filters
  - about 1 , 2
  - defining 1
  - exclusion filters 1 , 2
  - inclusion filters 1 , 2
- workload preprocessing
  - about 1 , 2
  - preprocessing 1
- workload replay
  - about 1 , 2
  - cancelling 1
  - exporting data 1
  - filters 1
  - importing data 1
  - monitoring 1 , 2
  - options 1 , 2
  - pausing 1
  - replaying 1 , 2
  - reporting 1
  - resuming 1
  - starting 1
  - steps 1
database upgrades
- testing 1
database version
- production system 1 , 2
- system running SQL Performance Analyzer 1 , 2
- test system 1 , 2
DBMS_SPM package
- LOAD_PLANS_FROM_SQLSET function 1
DBMS_SQLPA package
- CREATE_ANALYSIS_TASK function 1
- EXECUTE_ANALYSIS_TASK procedure 1 , 2 , 3 , 4 , 5
- REPORT_ANALYSIS_TASK function 1
- SET_ANALYSIS_TASK_PARAMETER procedure 1 , 2 , 3 , 4 , 5 , 6
DBMS_SQLTUNE package
- CREATE_TUNING_TASK function 1
- SELECT_SQL_TRACE function 1
DBMS_WORKLOAD_CAPTURE package
- ADD_FILTER procedure 1
- DELETE_FILTER procedure 1
- EXPORT_AWR procedure 1
- FINISH_CAPTURE procedure 1
- GET_CAPTURE_INFO procedure 1
- IMPORT_AWR function 1
- START_CAPTURE procedure 1
DBMS_WORKLOAD_REPLAY package
- ADD_CAPTURE function 1
- ADD_FILTER procedure 1
- ADD_SCHEDULE_ORDERING function 1
- BEGIN_REPLAY_SCHEDULE procedure 1
- CANCEL_REPLAY procedure 1
- COMPARE_PERIOD_REPORT procedure 1
- COMPARE_SQLSET_REPORT procedure 1
- CREATE_FILTER_SET procedure 1
- DELETE_FILTER procedure 1
- DELETE_REPLAY_INFO function 1
- END_REPLAY_SCHEDULE procedure 1
- EXPORT_AWR procedure 1
- GENERATE_CAPTURE_SUBSET procedure 1
- GET_DIVERGING_STATEMENT function 1
- GET_REPLAY_DIRECTORY function 1
- GET_REPLAY_INFO function 1 , 2
- IMPORT_AWR function 1
- INITIALIZE_CONSOLIDATED_REPLAY procedure 1
- INITIALIZE_REPLAY procedure 1
- LOAD_DIVERGENCE procedure 1
- PAUSE_REPLAY procedure 1
- PREPARE_CONSOLIDATED_REPLAY procedure 1
- PREPARE_REPLAY procedure 1
- PROCESS_CAPTURE procedure 1
- REMAP_CONNECTION procedure 1 , 2
- REMOVE_CAPTURE procedure 1
- RESUME_REPLAY procedure 1
- SET_CONSOLIDATED_DIRECTORY procedure 1
- SET_REPLAY_TIMEOUT procedure 1
- SET_USER_MAPPING procedure 1 , 2
- START_CONSOLIDATED_REPLAY procedure 1
- START_REPLAY procedure 1
- USE_FILTER_SET procedure 1

M

mapping table
- about 1
- creating 1 , 2
- moving 1 , 2

R

Real Application Testing
- about 1
- components 1
replay schedule
- about 1
- defining 1
- saving 1
- schedule orders
  - adding 1
  - removing 1
- workload captures
  - adding 1
  - removing 1

S

schedule order
- about 1
- viewing 1
SPA Quick Check
- configuring 1
- specifying default values 1
- using 1
- validating initialization parameter changes 1
- validating key SQL profiles 1
- validating pending optimizer statistics 1
- validating statistics findings 1
SQL Performance Analyzer
- about 1
- comparing execution plans 1
- comparing performance 1 , 2 , 3
- configuring a date to be returned by calls 1
- configuring a task 1
- configuring the number of rows to fetch 1
- configuring trigger execution 1
- creating a task 1 , 2 , 3
- executing the SQL workload 1 , 2
- executing the SQL workload after a change 1 , 2
- initial environment
  - establishing 1
- input source 1
- making a change 1
- methodology 1
- monitoring 1
- performance data
  - collecting post-change version 1
  - collecting pre-change version 1
  - comparing 1
- remote test execution 1 , 2
- reporting 1
- setting up the test system 1
- SQL Performance Analyzer report
  - active reports 1
  - general information 1 , 2
  - global statistics 1
  - global statistics details 1
  - result details 1
  - result summary 1
  - reviewing 1 , 2
- SQL tuning set
  - selecting 1 , 2
- SQL workload
  - capturing 1
  - executing 1 , 2
  - transporting 1
- system change
  - making 1
- task
  - creating 1 , 2
- usage 1
- using 1
- workflow
  - Exadata simulation 1
  - guided 1
  - optimizer statistics 1
  - parameter change 1
SQL Performance Analyzer Quick Check
- See: SPA Quick Check
SQL plan baselines
- creating 1
SQL statements
- regressed 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8
SQL Trace
- about 1
- enabling 1 , 2
- trace level 1
SQL trace files
- about 1
- moving 1 , 2
SQL trials
- about 1 , 2
- building
  - post-upgrade version 1 , 2 , 3
  - pre-upgrade version 1 , 2 , 3 , 4
- comparing 1
SQL tuning set
- about 1
- building 1
- comparing 1
- constructing 1
- converting 1

U

upgrade environment 1 , 2

W

Workload Analyzer
- about 1
- running 1
Workload Intelligence
- about 1 , 2
- BuildModel program
  - options 1
  - syntax 1
- creating a database user 1
- creating a job 1
- creating a workload model 1
- FindPatterns program
  - about 1
  - options 1
  - syntax 1
- GenerateReport program
  - about 1
  - options 1
  - syntax 1
- generating report 1
- identifying patterns 1
- LoadInfo program
  - about 1
  - options 1
  - syntax 1
- pattern 1
- sample scenario 1
- template 1
- using 1