historic undostats empty for PDB
From: Jack van Zanen <jack_at_vanzanen.com>
Date: Wed, 5 May 2021 12:27:18 +1000
Message-ID: <CAFeFPA-WA6_gBuD-Q8aU6iyx2bTEDdDEf=GkipcM0L-2HBX6sg_at_mail.gmail.com>
Hi ALl,
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
Date: Wed, 5 May 2021 12:27:18 +1000
Message-ID: <CAFeFPA-WA6_gBuD-Q8aU6iyx2bTEDdDEf=GkipcM0L-2HBX6sg_at_mail.gmail.com>
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
Received on Wed May 05 2021 - 04:27:18 CEST