Pluggable database AWR report contains entries from other pluggable databases
Hello,
We are running 19c, 19.27 EE, on Solaris 64-bit release 11.4.77. I am running AWR reports against a pluggable database. The AWR report contains entries from other pluggable databases in the same container database. This shows in the SQL ordered by Gets section and other SQL ordered by sections where applications are shown in the SQL Module column that can only connect to other pluggable databases in the same container database.
The steps I followed after connecting to the container database are:
alter session set container=<pluggable_db_name> ;
alter session set container_data=current_dictionary ;
alter system set awr_pdb_autoflush_enabled=true ;