The DBA_TABLESPACE_USAGE_METRICS View Needs to be Rebuilt in 10g_738101.1

rongshiyuan發表於2014-11-20
ViewUI

The DBA_TABLESPACE_USAGE_METRICS View Needs to be Rebuilt in 10g (Doc ID 738101.1)



In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2
Enterprise Manager for Oracle Database - Version: 10.1.0.2 to 10.2.0.4   [Release: 10.1 to 10.2]
Enterprise Manager Base Platform - Version: 10.1.0.2 to 10.2.0.4   [Release: 10.1 to 10.2]
Information in this document applies to any platform.
Enterprise Manager for RDBMS - Version: 10.1.0.2 to 10.2.0.4
Enterprise Manager Grid Control - Version: 10.1.0.2 to 10.2.0.4
RDBMS
EM
DBCONSOLE
GRID CONTROL

***Checked for relevance on 01-Nov-2011***

Symptoms

1) Attempts to use DBA_TABLESPACE_USAGE_METRICS have resulted in:

  • Inconsistent or incorrect values for DBA_TABLESPACE_USAGE_METRICS when compared to other space metrics using scripts for DBA_DATA_FILES, DBA_TABLESPACES, DBA_FREE_SPACE ... etc.
  • Incorrect, undersized or oversized values used by GC, EM or DBConsole for Tablespace metric ALERTs

2) Tablespaces can 'fill up' leading to potential database or application stoppage due to this improper metric assessment.  The problem is that by surpassing the expected ALERT thresholds DBAs are not warned of the space utilitization problem.

Changes

No known changes are associated with the problem:  

  • The problem can be intermittent for a single tablespace
  • The problem may occur for only one or a few of the total tablespaces measured or monitored by EM ( this is usually the case, making the problem more unexpected )

Cause

The problem is due to an incorrect definition for DBA_TABLESPACE_USAGE_METRICS.

Some of the problems that needed to be fixed in DBA_TABLESPACE_USAGE_METRICS include:

  • DBA_TABLESPACE_USAGE_METRICS usage should not include objects in the recycle bin 
  • Tablespace usage percentage differs depending on tables (views) used
  • Inconsistencies in tablespace usage calculation / not getting tablespace alerts Bug 6629893

The most recent fix for this problem is applying the patch for Bug 6629893 .


Solution

Download and apply the patch from Metalink for Bug 6629893 .
This is a generic patch which is available for:

  • 10.1.0.5
  • 10.2.0.2
  • 10.2.0.3
  • 10.2.0.4

As this is a generic patch, this means the patch is essentially a script that rebuilds DBA_TABLESPACE_USAGE_METRICS prerequisite objects.

This bug is fixed in the 10.2.0.5 patchset.


Comment: It is important to know if you attempt to assess 9i SPACE from 10g GRID CONTROL that 9i does *not* include the DBA_TABLESPACE_USAGE_METRICS view. No patch is available

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> desc DBA_TABLESPACE_USAGE_METRICS
ERROR:
ORA-04043: object DBA_TABLESPACE_USAGE_METRICS does not exist

References

BUG:6269576 - DISCREPANCY TABLESPACE GRAPH VS METRIC THRESHOLD
BUG:6490577 - TBSP USAGE PERCENTAGE IN ALL METRICS:TABLESPACES FULL DOES NOT CHANGE
BUG:6629893 - INCONSISTENCIES IN TABLESPACE USAGE CALCUALTION./ NOT GETTING TABLESPACE ALERTS
BUG:6665843 - SPACE USAGE REPORTED INCORRECTLY
BUG:6759910 - DBA_TABLESPACE_USAGE_METRICS USED_PERCENT SHOWS OVER 100%
 

Document Details

 
     
 

Related Products

 
     
 

Information Centers

 
     
 

Document References

 
No References available for this document.
     
 

Recently Viewed

 
     

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1340469/，如需轉載，請註明出處，否則將追究法律責任。

相關文章