any idea for v$undostat in CDB for PDB?
From: Thorsten Bruhns <"Thorsten>
Date: Sun, 13 May 2018 21:15:17 +0200
Message-ID: <CAAw07obXQuFTOVbmgjxZOsbrgjbkPjSSaO2e21=w5ng1nF9DVg_at_mail.gmail.com>
Hello,
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
Date: Sun, 13 May 2018 21:15:17 +0200
Message-ID: <CAAw07obXQuFTOVbmgjxZOsbrgjbkPjSSaO2e21=w5ng1nF9DVg_at_mail.gmail.com>
Hello,
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
-- http://www.freelists.org/webpage/oracle-lReceived on Sun May 13 2018 - 21:15:17 CEST