RE: V$filespace_usage

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Wed, 21 Nov 2012 16:48:54 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD11217347F_at_G5W2734.americas.hpqcorp.net>



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

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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 11.2.0.2 and 11.1.0.7

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 21 2012 - 17:48:54 CET

Original text of this message