053试题 117 - database replay
题目:
117.Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)
A. multiplexing of the control file
B. adding the redo log member to the database
C. database and operating system upgrades
D. changing the database storage to ASM-managed storage
参考文档 CD
解析
题目意思是,使用database replay 可以测试哪两个更改及其对系统的影响。
DB replay主要是测试系统更改的。所以选择CD 。
参考文档:
https://docs.oracle.com/cd/E11882_01/server.112/e41481/dbr_intro.htm#RATUG104
8 Introduction to Database Replay
You can use Database Replay to capture a workload on the production system and replay it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload. This enables you to test the effects of a system change without affecting the production system.
Database Replay supports workload capture on a system running Oracle Database 10g Release 2 and newer releases. In order to capture a workload on a system running Oracle Database 10g Release 2, the database version can be 10.2.0.4 or higher. Workload replay is only supported on systems running Oracle Database 11g Release 1 and newer releases.
Note:
To use the workload capture feature on a system running Oracle9i Database or an earlier version of Oracle Database 10g Release 2, contact Oracle Support for more information.
Analyzing the effect of system changes using Database Replay involves the following steps, as illustrated in Figure 8-1:
Figure 8-1 Database Replay Workflow
Description of "Figure 8-1 Database Replay Workflow"
-
On the production system, capture the workload into capture files, as described in "Workload Capture".
-
Copy the capture files to the test system and preprocess them, as described in "Workload Preprocessing".
-
On the test system, replay the preprocessed files, as described in "Workload Replay".
-
Using the reports generated by Database Replay, perform detailed analysis of both the workload capture and workload replay, as described in "Analysis and Reporting".
END