Re: V$filespace_usage
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: "Powell, Mark" <mark.powell2@xxxxxx>
- Date: Wed, 21 Nov 2012 17:20:12 +0000
nope
its odder than that - the db that had the problem now has data there, but
another one has the data missing.. It'll be an SR.
On Wed, Nov 21, 2012 at 4:48 PM, Powell, Mark <mark.powell2@xxxxxx> wrote:
> 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
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts:
