AWR Report run from a Pluggable Database (PDB) Runs Much Slower than from a Container Database (CDB) on 12c
(Doc ID 1995938.1)
Last updated on MAY 12, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
The multitenant architecture for 12c enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many pluggable databases (PDBs).
Symptoms
- Automatic Workload Repository (AWR) is running much slower in a pluggable database (PDB) than in a container database (CDB) in 12c
- By running 10046 trace, a recursive sql was identified as running much slower in the pluggable database (PDB) than in the container database (CDB). The query is:
Even though the data in the PDB is essentially the same as in the CDB, the PDB processes far more rows (number of rows processed is 334.8 million instead of 17,186).
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |