Upgrade Oracle DBA 11g to Oracle Database 12c — Question 31

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?

Answer options

• 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

Correct answer: D

Explanation

The correct answer is D because using the SQL Tuning Set allows for a focused analysis of resource-intensive SQL statements, which is essential for effective capacity planning. Options A and C involve analyzing workloads but do not specifically target the tuning process, while B focuses on replaying workloads individually, which may not provide a comprehensive view of capacity needs across all PDBs.