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.
Also in AWR Warehouse, there are no reports can be generated for a PDB.
Any comments are much appreciated!
Larry