EM 11g: How to Restore Tablespace Metric Collection to 24 from an Altered Value in Enterprise Manager 11g Grid Control (Doc ID 1666250.1)

Last updated on JANUARY 18, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 11.1.0.1 and later
Information in this document applies to any platform.

Goal

Enterprise Manager collects tablespace metric information from the MGMT$DB_DATAFILES & MGMT$DB_TABLESPACES views every 24 hours by default. This cycle may have been altered if a user is interested in seeing more request collections for this parameter. Changing the collection cycle back to every 24 hours to decrease system activity is described here.

Note:

Increasing the frequency of metric data collection and/or upload can impact the resources required to reliably monitor the enterprise with Enterprise Manager.

Oracle provides guidelines for resource application in its sizing guide. For EM 11g, see the following reference:

Oracle® Enterprise Manager Administration
11g Release 1 (11.1.0.1)
E16790-04
Chapter 9 Sizing Your Enterprise Manager Deployment

If symptoms of undersizing (for instance, periodic backups of uploads from agent to OMS or OMS to repository, or page display times extending or page access faults) are encountered, it may be time to consider application of additional resources to accommodate the increased transaction load.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms