Issue: In 19c database, while generating AWR report from PDB level, got the below error. In 12cR1 - We can only generate statistics and run the Workload Repository (AWR) report from CDB level. Since 12.2, if we want to generate statistics and run AWR report from PDB level, we have to change awr_pdb_autoflush_enabled parameter to TRUE. Error: ERROR at line 1: ORA-20200: Database/Instance 2832289441/1 does not exist in AWR_PDB_DATABASE_INSTANCE ORA-06512: at line 27 Solution: alter session set container=ORCL; >>>> Set the container Name alter system set awr_pdb_autoflush_enabled=true; conn system/<pwd>@orclcdb >>>> Login into PDB database alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both; >>> Set the arameter to avoid performance issue while generating snapshot at the same time in CDB and PDB level. exec dbms_workload_repository.create_snapshot(); SQL> @?/rdbms/admin/awrrpt.sql Console Log: SQL> show pdbs CON_ID CON
Yet another blog for dba's. Shared my work experience here. Hope it will be useful for you guys all.