You want to consolidate databases for the CRM, ERP, and SCM applications by migrating
them to pluggable databases (PDBs). You have already created a test system to support
the consolidation of databases in a multitenant container database (CDB) that has multiple
PDBs. What is the easiest way to perform capacity planning for consolidation?
A.
capturing the most resource-intensive SQL statements in a SQL Tuning Set on the
production system and using the SQL Performance Analyzer on the test system
B.
capturing the workload on the production system and replaying the workload for one PDB
at a time on the test system
C.
capturing the workload on the production system and using Consolidated Database
Replay to replay the workload of all production systems simultaneously for all PDBs
D.
capturing the most resource-intensive SQL statements in a SQL Tuning Set on the
production system and using the SQL Tuning Advisor on the test system
C
Consolidated Database Replay enables you to replay multiple workloads captured from one or multiple systems concurrently. During the replay, every workload capture that is consolidated will start to replay when the consolidated replay begins. Depending on the use case, you can employ various workload scale-up techniques when using Consolidated Database Replay.
D is my choice.
Hmm, I too taught C but for capacity planning isn’t A more appropriate?
Database replay will be helpful to check interoperability & compatability issues rather than capacity planning.
Although capacity plaanning is driven by App & business growth factors, in the given answwerset. D
Tuning advisor would give recommendations on instance tuning and config related hence aiding in capacity planning
Also see the trick in the question they have given option A & D so close.
C is my Choise
https://docs.oracle.com/database/121/RATUG/GUID-29988B63-F974-46EF-9AAD-3D04AF774337.htm#RATUG4122
11. Start the consolidated replay:
EXEC DBMS_WORKLOAD_REPLAY.START_CONSOLIDATED_REPLAY;