Re: dba_tablespace_usage_metrics view returns zero rows from Standby

From: Andy Klock <andy@xxxxxxxxxxxxxxx>
To: dmarc-noreply@xxxxxxxxxxxxx
Date: Tue, 30 Jan 2018 13:45:25 -0500

On Tue, Jan 30, 2018 at 12:06 PM, Brad Peek <dmarc-noreply@xxxxxxxxxxxxx>
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.

References:
- dba_tablespace_usage_metrics view returns zero rows from Standby
  - From: Brad Peek

Other related posts:

» dba_tablespace_usage_metrics view returns zero rows from Standby- Brad Peek
» Re: dba_tablespace_usage_metrics view returns zero rows from Standby - Andy Klock