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@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of D'Hooge Freek Sent: woensdag 21 november 2012 10:00 To: niall.litchfield@xxxxxxxxx; 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@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l