RE: V$filespace_usage
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "niall.litchfield@xxxxxxxxx" <niall.litchfield@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Nov 2012 10:09:26 +0100
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
Other related posts:
