RE: V$filespace_usage

From: Powell, Mark <>
Date: Wed, 21 Nov 2012 16:48:54 +0000
Message-ID: <>

Any chance the database parameter statistics_level = BASIC for any of these databases?

-----Original Message-----

From: [] On Behalf Of Niall Litchfield Sent: Wednesday, November 21, 2012 2:02 AM To: ORACLE-L
Subject: V$filespace_usage

Before I log yet another SR with Oracle, is anyone aware of the circumstances under which the above view is not populated? I've pushed some monitoring based on dba_tablespace_usage_metrics into production, and now found that a few databases don't have this dynamic performance view populated and thus the monitoring fails. I'd expect OEM to suffer the same issue since I believe it relies on the same view. Interestingly the AWR view dba_hist_tablespace_usage appears to indicate that this occurs intermittently (one day this DB is 6tb in size, the next 0). Versions we see this on and


-- Received on Wed Nov 21 2012 - 17:48:54 CET

Original text of this message