Index
C
- capture subset
- 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
- 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
- replay filter set
- about 12.1.7
- reporting 9.4, 13
- 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
- workload preprocessing
- workload replay
- database upgrades
- testing 8
- database version
- DBMS_SPM package
- LOAD_PLANS_FROM_SQLSET function 6.2.6
- DBMS_SQLPA package
- DBMS_SQLTUNE package
- DBMS_WORKLOAD_CAPTURE package
- 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
S
- schedule order
- about 15.2.4.1.2
- viewing 15.4.3.3
- SPA Quick Check
- 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
- remote test execution 8.1.4, 8.2.1
- reporting 2.7
- setting up the test system 2.2
- SQL Performance Analyzer report
- SQL result sets
- validating 3.3.8
- SQL tuning set
- SQL workload
- system change
- making 5
- task
- usage 1.1
- using 2
- workflow 2
- SQL Performance Analyzer Quick Check
- See: SPA Quick Check
- SQL plan baselines
- creating 6.2.6
- SQL statements
- SQL Trace
- SQL trace files
- SQL trials
- SQL tuning set
W
- Workload Analyzer
- Workload Intelligence
- about 14.1, 14.1.1
- BuildModel program
- creating a database user 14.2.1
- creating a job 14.2.2
- creating a workload model 14.2.3
- FindPatterns program
- GenerateReport program
- generating report 14.2.5
- identifying patterns 14.2.4
- LoadInfo program
- pattern 14.1.1
- sample scenario 14.3
- template 14.1.1
- using 14.2