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
C
https://docs.oracle.com/database/121/RATUG/GUID-29988B63-F974-46EF-9AAD-3D04AF774337.htm#RATUG4122
Thanks Vonpire!
C.
Replaying a Consolidated Workload with APIs
https://docs.oracle.com/database/121/RATUG/GUID-29988B63-F974-46EF-9AAD-3D04AF774337.htm#RATUG4122
C
C
This link seems to suggest consolidated replay
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;
C