Sunday, 6 October 2013

Unable to see data for Oracle Database Monthly Space Usage report for all Databases in Oracle Enterprise Manager 12c

Unable to see data for Oracle Database Monthly Space Usage report for all Databases in Oracle Enterprise Manager 12c


Trying to get a report on Oracle Database Space Usage but databases listed in "Outstanding Tablespace Full Alerts by Databases" were not appearing in "Allocated Space Usage by Database.

Digging deep found out that the Tablespace Allocation metric was disabled for some databases!

So tried below in Enterprise Manager:

Target > Databases > Choose Database with Metrics issue > Menu > Monitoring > All Metrics > Click "Tablespace Allocation"

Click Enable

  • For single database
Targets > Databases > Choose Database with Metrics issue > Menu > Monitoring > All Metrics > Click "Tablespace Allocation"

Click Enable

  • For Multiple Databases
-- Create Template with this metric enabled and push the template to multiple databases

UI > Enterprise > Monitoring > Monitoring Templates > Click Create and add the metric


Wait at-least 72 hours and check the status again. It should show data now.

No comments:

Post a Comment