Managing Oracle Databases › Oracle Support

Oracle Support

CA SRM assembles and presents the information to manage your database storage more efficiently. CA SRM collects a variety of data to assist you in such tasks as tuning your system, setting alerts, planning capacity, reporting on raw devices, and so on. You can display unified views of data collected from multiple database instances running on different platforms. CA SRM logs on to all the databases automatically at scheduled times.

You can use CA SRM to perform the following tasks:

• Present complete logical volume information by combining data reported by Oracle with raw device data collected by the CA SRM Agent
• Monitor size, free space, and occupied space information for database instances, tablespaces, users, and data files
• Analyze trends for database instances, tablespaces, data files, segments, extents, users, and redo logs
• Monitor redo log switching frequency
• Set an alert to notify you when a database instance is down
• Set an alert to notify you if a data file is in the backup state
• Assemble I/O statistics and use them to tune your I/O performance

CA SRM collects and stores information from Oracle computers as CA SRM objects. You can filter, sort, and query these objects, represent them graphically, and customize the presentation in other ways.

Note: To minimize the impact of data collection on system performance, limit the scope of information you want to collect and specify the computers from which you want this information collected.

CA SRM does not support the scenario of changing the instance that is pointed to by an already used Oracle service.