Re: dba_tablespace_usage_metrics view returns zero rows from Standby
From: Andy Klock <andy_at_oracledepot.com>
Date: Tue, 30 Jan 2018 13:45:25 -0500
Message-ID: <CADo_RaOp35innu0F7odK-rQkTm_hNRf8tUwipCw2b8T8TGfNzQ_at_mail.gmail.com>
Date: Tue, 30 Jan 2018 13:45:25 -0500
Message-ID: <CADo_RaOp35innu0F7odK-rQkTm_hNRf8tUwipCw2b8T8TGfNzQ_at_mail.gmail.com>
On Tue, Jan 30, 2018 at 12:06 PM, Brad Peek <dmarc-noreply_at_freelists.org> wrote:
> I probably knew this at one time, but today I was surprised to see that
> the DBA_TABLESPACE_USAGE_METRICS view doesn't return any rows when run from
> a Physical Standby that is open for read-only. I tried on a couple of
> standbys to make sure it wasn't something about that one DB. DB Version
> is 12.1.0.2
>
>
Best guess is that v$filespace_usage isn't maintained in the standby controlfile.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 30 2018 - 19:45:25 CET