Reporting

CA SRM produces the following reports:

Oracle Instances Summary
Oracle Tablespaces Summary
Oracle Datafiles Summary
Oracle Segments Summary
Oracle Extents Summary

For more information about available Oracle reports and the data included in each report, see the online help.

You can use CA SRM to enhance the performance of your Oracle system and solve Oracle-related problems.

Typically, backups are scheduled to run (and terminate) at known times; therefore, you can define an Automate service to alert you that a database instance or a data file are in the backup state after the expected termination time. A data file that is still in the backup state after it should have terminated may indicate a problem that occurred during the backup and that the backup data may be inconsistent.

You can monitor the frequency of redo log switching. When the number of redo log switches exceeds the limit for the time interval that you defined, CA SRM can issue an alert. This condition may indicate a problem that occurred during the backup of a redo switch log or of an unusually high transaction activity.

You can produce reports of the I/O activity for selected database instances and data files. You can use the information to tune your database and improve performance. For example, you can do the following:

Identify segments with the highest I/O activity and place them in separate data files to improve access times.
Identify the data files that grow in size and define an appropriate growth plan for them.
Group all the files with the lowest I/O. You can then determine which files you want to backup regularly, semi-regularly, or never. This lets you lower network traffic and free backup media.

Note: Objects COMPUTER and SERVER are equivalent and can be used interchangeably.