When statistics data collection is enabled, Enterprise Manager stores in its statistics database the following information for each managed device on which the Data Collection Agent is installed:
You can use the collected statistics to display standardized reports about the health and performance of managed devices in your network. This helps you identify any systems that are not performing at full capacity and assists you in determining when you should add new devices.
To start collecting statistics, you must enable the collect statistics data feature and install the Data Collection Agent.
By default, Enterprise Manager stores health and performance monitoring statistics data in the database located on its hard drive. You have the option of configuring Enterprise Manager to store these statistics on a hard drive that is separate (external) from the Enterprise Manager system. Storing statistics on an external database clears space on Enterprise Manager for more storage of archives, images, configuration files, and so forth. A space dedicated only to health and performance monitoring statistic data can also provide you with more historical data storage.
To use an external database for health and performance monitoring statistics storage, you must create the external database and then configure Enterprise Manager to store data on that database.
If you previously collected data locally on the Enterprise Manager system, you have the option to back up and restore the data to the external database.
Before configuring Enterprise Manager to store statistics data on an external database, you must create an external database on a system that is running Oracle MySQL version 5.1 with patch 52 or later.
On the system that meets the aforementioned requirements, use the following MySQL commands in this sequence to create an external database.
If you want to transfer health and performance monitoring data that is currently stored in the local database to your external database perform the following steps.
After you have created the external database on the remote system, you can configure Enterprise Manager to store data there.
Configuring Enterprise Manager to store health and performance monitoring statistics on an external database frees system resources, and provides you with space to store statistics that is limited only by the system's hard drive on which you configure the external database.
If you have two Enterprise Manager systems configured as a high availability system, configure the external database the same way on each system.