Database Tuning (MOSC)

MOSC Banner

PDB AWR report contains data from other PDBs in the Container

Hello,

I'm running 19.26 EE on Solaris 64 bit 11.4.77.182.2 (SPARC) using multi-tenanted architecture. This is not a RAC configuration. I create snapshots at pdb level then generate an awr report for these snapshots. The awr report contains data from other pdbs in the container. This is evidenced in the SQL Module column of the for SQL ordered by CPU Time and the SQL ordered by User I/O Time sections in the awr report. This is also confirmed by running:

select unique module from sys.wrh$_sqlstat where module is not null and module like '<executable_redacted>%'

against the pdb. The modules reported are from application servers that cannot connect to the pdb that I'm running the awr report against. These application servers connect to other pdbs in the container. Each single application server can only connect to a single pdb.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center