Re: V$filespace_usage

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 21 Nov 2012 17:20:12 +0000
Message-ID: <CABe10sa_4YwXE5pUy6Epm40kzYCJWsbXPyzCWkCcftG22Hin4A_at_mail.gmail.com>



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_at_hp.com> wrote:

> 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 21 2012 - 18:20:12 CET

Original text of this message