The flashcards below were created by user
on FreezingBlue Flashcards.
Which Oracle product can capture production workload and replay on a test server?
Which Oracle procduct can predict the impact of any change when using Database Replay?
SQL Performance Analyzer
What work is captured as part of Database Replay?
- ALTER SESSION
- ALTER SYSTEM
What work is not captured as part of Database Replay?
- Flashback Queries
- Direct Path Loads
- Database Links
- External Tables
- Oracle Streams
- non-SQL object access
- Distributed Transaction
What packages are used to capture and replay data?
What are the steps for capturing data in Database Replay?
- CREATE DIRECTORY db_replay_capture_dir AS '/u01/db_replay_capture';
- CREATE USER db_replay_test IDENTIFIED BY db_replay_test;
- GRANT CONNECT, CREATE TABLE TO db_replay_test;
- SHUTDOWN IMMEDIATE
- BEGIN DBMS_WORKLOAD_CAPTURE.start_capture
- Do some work!!!
Which view contains information about Database Replay Capture?
How is the AWR for a Database Replay extracted?
DBMS_WORKLOAD_CAPTURE.EXPORT_AWR (capture_id => nn);
What are the steps for replaying data in Database Replay?
- Create directory and user as for caputre
- Start the following
- Calibrate clients/hosts using commandline utility wrc
Which Database Replay command will stop a replay?
How can specific session workloads be excluded from capture?
How is a Workload filter disabled?
What is Workload Replay Client?
A commandline utility that calibrates the client
What is the default mode for WRC?
In DBMS_WORKLOAD_CAPTURE.START_CAPTURE, how is the capture set to be manually stopped?
set parameter duration => NULL
What generates reports based on the Database Replay?
What can Database Replay Workload reports tell us?
- Data divergence
- Errors during replay
- Performance differences between capture and replay
Before capturing a workload, what is the best first step?
Restart the instance
What does connect_time_scale Replay Option do?
- Adjusts the connect times of sessions in the replay
- 100 is same as capture
What does think_time_scale Replay Option do?
- Adjusts think time of sessions in the replay
- 100 is same as capture
What does think_time_auto_correct Replay Option do?
If TRUE can help the replay catch up with the capture
What is specific about wrc user?
Must be DBA and NOT SYS
When wanting to a detailed comparison between capture and replay what can be used?
AWR reports from each session.
Give examples of what Database Replay can assist in advising.
- Upgrading the OS
- Converting from a single instance to RAC