RE: V$filespace_usage
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Nov 2012 16:48:54 +0000
Any chance the database parameter statistics_level = BASIC for any of these
databases?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
