MIME-Version: 1.0
From: Jack van Zanen <jack@vanzanen.com>
Date: Wed, 5 May 2021 12:27:18 +1000
Message-ID: <CAFeFPA-WA6_gBuD-Q8aU6iyx2bTEDdDEf=GkipcM0L-2HBX6sg@mail.gmail.com>
Subject: historic undostats empty for PDB
To: "oracle-l@freelists.org" <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="000000000000ba0b7b05c18bef64"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: jack@vanzanen.com
--000000000000ba0b7b05c18bef64
Content-Type: text/plain; charset="UTF-8"

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

--000000000000ba0b7b05c18bef64
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi ALl,</div><div><br></div><div><br></div><div>I wan=
ted to look into the historical undostats for one of my PDB&#39;s=C2=A0and =
noticed there are no rows whatsoever when querying dba_hist_undostat in the=
 PDB and only rows for con_id 1 in the root.</div><div>There must be some s=
etting that even after googling is escaping me.</div><div><br></div><div>An=
yone can point me in the right direction</div><div><br></div><div>Oracle 12=
.2.0.1 - Exadata</div><div><br></div><div><br></div><div><br></div><br clea=
r=3D"all"><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D=
"gmail_signature"><div dir=3D"ltr"><div>Jack van Zanen</div><div><br></div>=
<div><img src=3D"https://docs.google.com/uc?id=3D0BwovDucFT1fXaEREVHNWRWZyN=
jg&amp;export=3Ddownload" width=3D"96" height=3D"96"><br>------------------=
------- <br>This e-mail and any attachments may contain confidential materi=
al for the sole use of the intended recipient. If you are not the intended =
recipient, please be aware that any disclosure, copying, distribution or us=
e 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.<br>Thank=
 you for your cooperation </div></div></div></div></div>

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