1. Home
  2. Flashcards
  3. Preview

Oracle OCP 9i to 11g Database Replay

  1. Which Oracle product can capture production workload and replay on a test server?
    Database Replay
  2. Which Oracle procduct can predict the impact of any change when using Database Replay?
    SQL Performance Analyzer
  3. What work is captured as part of Database Replay?
    • DDL
    • DML
    • ALTER SESSION
    • ALTER SYSTEM
  4. 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
  5. What packages are used to capture and replay data?
    • DBMS_WORKLOAD_CAPTURE
    • DBMS_WORKLOAD_REPLAY
  6. 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
  7. Which view contains information about Database Replay Capture?
    DBA_WORKLOAD_CAPTURES
  8. How is the AWR for a Database Replay extracted?
    DBMS_WORKLOAD_CAPTURE.EXPORT_AWR (capture_id => nn);
  9. 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;
  10. Which Database Replay command will stop a replay?
    DBMS_WORKLOAD_REPLAY.cancel_replay
  11. How can specific session workloads be excluded from capture?
    DBMS_WORKLOAD_CAPTURE.ADD_FILTER
  12. How is a Workload filter disabled?
    DBMS_WORKLOAD_CAPTURE.DELETE_FILTER
  13. What is Workload Replay Client?
    A commandline utility that calibrates the client
  14. What is the default mode for WRC?
    Replay
  15. In DBMS_WORKLOAD_CAPTURE.START_CAPTURE, how is the capture set to be manually stopped?
    set parameter duration => NULL
  16. What generates reports based on the Database Replay?
    DBMS_WORKLOAD_CAPTURE.REPORT
  17. What can Database Replay Workload reports tell us?
    • Data divergence
    • Errors during replay
    • Performance differences between capture and replay
  18. Before capturing a workload, what is the best first step?
    Restart the instance
  19. What does connect_time_scale Replay Option do?
    • Adjusts the connect times of sessions in the replay
    • 100 is same as capture
  20. What does think_time_scale Replay Option do?
    • Adjusts think time of sessions in the replay
    • 100 is same as capture
  21. What does think_time_auto_correct Replay Option do?
    If TRUE can help the replay catch up with the capture
  22. What is specific about wrc user?
    Must be DBA and NOT SYS
  23. When wanting to a detailed comparison between capture and replay what can be used?
    AWR reports from each session.
  24. 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

  1. Home
  2. Flashcards
  3. Preview