Oracle
1Z0-063 · Question #166
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…
The correct answer is D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production. See the full explanation below for the reasoning.
Question
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?
Options
- Acapturing the most resource-intensive SQL statements in a SQL Tuning Set on the production
- Bcapturing the workload on the production system and replaying the workload for one PDB at a
- Ccapturing the workload on the production system and using Consolidated Database Replay to
- Dcapturing the most resource-intensive SQL statements in a SQL Tuning Set on the production
How the community answered
(19 responses)- A5% (1)
- B5% (1)
- C16% (3)
- D74% (14)
Community Discussion
No community discussion yet for this question.