Home
Flashcards
Preview
Oracle OCP 9i to 11g Database Replay
Home
Get App
Take Quiz
Create
Which Oracle product can capture production workload and replay on a test server?
Database Replay
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?
DDL
DML
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?
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_REPLAY
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
STARTUP
BEGIN DBMS_WORKLOAD_CAPTURE.start_capture
Do some work!!!
DBMS_WORKLOAD_CAPTURE.finish_capture
Which view contains information about Database Replay Capture?
DBA_WORKLOAD_CAPTURES
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
DBMS_WORKLOAD_REPLAY.process_capture
DBMS_WORKLOAD_REPLAY.initialize_replay
DBMS_WORKLOAD_REPLAY.prepare_replay
Calibrate clients/hosts using commandline utility wrc
DBMS_WORKLOAD_REPLAY.start_replay;
Which Database Replay command will stop a replay?
DBMS_WORKLOAD_REPLAY.cancel_replay
How can specific session workloads be excluded from capture?
DBMS_WORKLOAD_CAPTURE.ADD_FILTER
How is a Workload filter disabled?
DBMS_WORKLOAD_CAPTURE.DELETE_FILTER
What is Workload Replay Client?
A commandline utility that calibrates the client
What is the default mode for WRC?
Replay
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?
DBMS_WORKLOAD_CAPTURE.REPORT
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.
Debugging
Upgrading the OS
Converting from a single instance to RAC
Author
Tralala
ID
191250
Card Set
Oracle OCP 9i to 11g Database Replay
Description
Oracle OCP 9i to 11g Database Replay
Updated
2014-05-10T13:15:50Z
Home
Flashcards
Preview