Oracle Database 12c: Advanced Administration — Question 101

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 Advisor on the test system allows for targeted optimization of the most resource-intensive SQL statements, which is crucial for effective capacity planning. Options A and C involve SQL Performance Analyzer and Consolidated Database Replay, which may not provide the same level of focused tuning for individual PDBs. Option B, while capturing workload, does not leverage the SQL Tuning Advisor specifically for optimization.