any idea for v$undostat in CDB for PDB?

From: Thorsten Bruhns <"Thorsten>
Date: Sun, 13 May 2018 21:15:17 +0200
Message-ID: <>

I am working on Multitenant Support for mk_oracle in Check_MK. There is one check for statistical data from v$undostat and monitoring of undo_retention.
The plugin use data from v$undostat:
select ...
from v$undostat

The v$undostat has a problem in CDB environments. It shows only the data for the current CDB/PDB. Is there any solution for a sql which shows the data for all pdb without changing the current container?

Kind Regards
Thorsten Bruhns

Received on Sun May 13 2018 - 21:15:17 CEST

Original text of this message