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.