Hi Jack,
The awr_pdb_autoflush_enabled parameter will enable AWR on the PDB.
Described here for 12.2
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/AWR_PDB_AUTOFLUSH_ENABLED.html#GUID-08FA21BC-8FB1-4C51-BEEA-139C734D17A7
I have not done this on 12.2, but have on a 19.8 PDB.
*Here is a PDB with AWR enabled:*
SQL> @getparm pdb%flush
V$PARAMETER for pdb%flush report for
Database: PDB4.JKS.COM
Date/Time: 05/11/2021 10:24:55
DEF SESS SYS
NAME INST VALUE VAL? MOD? MOD?
----------------------------------- -----
-------------------------------------------------- ---- ---- ----
awr_pdb_autoflush_enabled 1 TRUE N N I
awr_pdb_autoflush_enabled 2 TRUE Y N I
2 rows selected.
SQL> select distinct con_id from dba_hist_undostat;
CON_ID
----------
6
1 row selected.
*And here is a PDB where AWR is not enabled*
SQL> @getparm pdb%flush
V$PARAMETER for pdb%flush report for
Database: PDB1.JKS.COM
Date/Time: 05/11/2021 10:25:53
DEF SESS SYS
NAME INST VALUE VAL? MOD? MOD?
----------------------------------- -----
--------------------------------------------------
---- ---- ----
awr_pdb_autoflush_enabled 1 FALSE Y N I
awr_pdb_autoflush_enabled 2 FALSE Y N I
2 rows selected.
SQL> select distinct con_id from dba_hist_undostat;
no rows selected
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill
On Tue, May 4, 2021 at 7:28 PM Jack van Zanen <jack@xxxxxxxxxxxx> wrote:
Hi ALl,
I wanted to look into the historical undostats for one of my PDB's and
noticed there are no rows whatsoever when querying dba_hist_undostat in the
PDB and only rows for con_id 1 in the root.
There must be some setting that even after googling is escaping me.
Anyone can point me in the right direction
Oracle 12.2.0.1 - Exadata
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
