Database Replay

These questions are based on 1Z0-050 – Oracle Database 11g New Features
Oracle Self Test Software Practice Test.


Objective: Database replay.
Sub-objective: Overview of workload capture and replay.


Single answer, multiple choice


You plan to upgrade your operating system and want to use Database Replay to analyze the impact of the upgrade. Which statement is true?



  1. When replaying workload, you must specify a single replay client that can access the capture directory.
  2. When you preprocess captured workload, connections are automatically remapped.
  3. To successfully replay captured workload, the replay database should be identical to what the capture database was when workload capture began.
  4. You can replay the captured workload multiple times, but each time the workload must be preprocessed.

Answer:
C. To successfully replay captured workload, the replay database should be identical to what the capture database was when workload capture began.


Tutorial:
To successfully replay captured workload, the replay database should be identical to what the capture database was when workload capture began so the database can be restored and the workload replayed against it. You also should note that if your workload is time sensitive, you should reset the system clock on the replay system to the time you started the capture.


The option that states when replaying workload, you must specify a single replay client that can access the capture directory is incorrect. You can specify one or more replay clients. Each replay client can control one or more workload sessions.


The option that states when you preprocess captured workload, connections are automatically remapped is incorrect. Preprocessing simply converts the captured data into files that can be replayed, creating the needed metadata. Preprocessing does not remap any connections. You must do that yourself.


The option that states you can replay the captured workload multiple times, but the workload must be preprocessed each time is incorrect. The captured workload only has to be preprocessed once and then can be replayed multiple times.


Reference:
Oracle University – Oracle Database 11g: New Features for Administrators – Chapter 5: Database Replay – Replay Considerations
D50081GC10
Edition 1.0
July 2007
D51900


Oracle Database Performance Tuning Guide11g Release 1 (11.1)
Part Number B28274-01
Database Replay
http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/wcr.htm#BABIEJII

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment:

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>