Database Tuning (MOSC)

MOSC Banner

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 ;

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