RE: V$filespace_usage
Date: Wed, 21 Nov 2012 10:09:26 +0100
Message-ID: <4814386347E41145AAE79139EAA398982F74C2D09D_at_ws03-exch07.iconos.be>
Apologies, I mixed up your post with the question about dba_hist_sqlstat
I need more coffee
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of D'Hooge Freek
Sent: woensdag 21 november 2012 10:00
To: niall.litchfield_at_gmail.com; ORACLE-L
Subject: RE: V$filespace_usage
The control_management_pack_access parameter controls the diagnostic and tuning pack usage, so if this is turned off it can explain why the views are not populated. This parameter exists since 11.1 and is set default to "diagnostic+tuning" for enterprise edition databases and to "none" for standard edition.
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams038.htm#I1010296
Kind regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: woensdag 21 november 2012 8:02
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 21 2012 - 10:09:26 CET