Re: historic undostats empty for PDB

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> _at_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

1 row selected.

*And here is a PDB where AWR is not enabled*

SQL> _at_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_at_vanzanen.com> 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
>

--
http://www.freelists.org/webpage/oracle-l