RE: V$filespace_usage

From: D'Hooge Freek <>
Date: Wed, 21 Nov 2012 10:00:06 +0100
Message-ID: <>

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.

Kind regards,

Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

-----Original Message-----

From: [] On Behalf Of Niall Litchfield Sent: woensdag 21 november 2012 8:02
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 and


-- Received on Wed Nov 21 2012 - 10:00:06 CET

Original text of this message