AWR Report run from a Pluggable Database (PDB) Runs Much Slower than from a Container Database (CDB) on 12c
Last updated on APRIL 11, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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).
- 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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms