Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Why is AWR_PDB_AUTOFLUSH_ENABLED set to false in a PDB

Larry LiangDec 13 2024 — edited Dec 13 2024

Hello,

We are using 19.3 version of oracle databases.

I am looking for input and oracle best practice on this parameter in a PDB: AWR_PDB_AUTOFLUSH_ENABLED. AWR snapshots are disabled (false) by default in a PDB by oracle, but true only in a CDB.

Clearly we cannot generate AWR reports for PDBs if it's not enabled, and cannot produce Workload Analysis for a PDB in OEM either.

We assume there must be a good reason why oracle default it to false in a PDB and what's the best practice and recommendations for the parameter if we should set it to true.