Overview - SRM Oracle Agent

Topics | Related Topics

• Introduction
• Supported Job Types for Data Collection
  • Discovery Job
  • Discovery and Analysis Job
• Tree Level in SRM Oracle Agent
• Configuration Considerations
• License Requirement

Introduction

The SRM Oracle Agent gathers statistics on all levels of the Oracle Database.

Data collected by the SRM Oracle Agent is summarized by many types of reports that may be further customized with user-selected filters and charts in the Report Manager.

For the SRM Oracle Agent, the agent software is installed on a proxy client. For more information on installing the proxy client, see Deployment - SRM Oracle Agent. Once the installation is complete, the agent and the oracle database information must be configured from the client level in the CommCell Console. For step-by-step instructions see, Add Oracle Database.

Supported Job Types for Data Collection

This agent supports two job types for data collection:

• Discovery
• Discovery and Analysis

Discovery Job

This job collects detailed statistics including information about databases, datafiles, tables, tablespaces, instances, users, ASM and RMAN; general information about indexes is also collected. Collections using the Discovery level job require minimal processing on the proxy server, and may be run either throughout the day or during off-peak hours. If you use the Discovery level job, you will not receive the same degree of detail on index related reports as the Analysis level template.

Discovery and Analysis Job

This job collects detailed statistics including information about databases, datafiles, tables, tablespaces, indexes, instances, users, ASM and RMAN. Collections using the Analysis level job for this agent require minimal processing on the proxy server, similar to the Discovery level job, and may be run either throughout the day or during off-peak hours.

See Reports - SRM Oracle Agent for more information about which reports require Analysis level data collection.

Tree Level in SRM Oracle Agent

When the SRM Oracle Agent is installed, the following levels are automatically created in the CommCell Browser.

//rdlab04:1520/rman10g:	Client
Oracle:	Agent
default:	Subclients
Instances:	This level displays Instances information for the SRM Oracle Agent's client computer. Instances associated with the client computer are populated under this level after completion of the first Data Collection operation. For more information, see SRM Oracle Agent Summaries.
Tablespaces:	This level displays Tablespaces information of Oracle Instance for the SRM Oracle Agent's client computer(s). Tablespaces associated with the Instance are populated under this level after completion of the first Data Collection operation. For more information, see SRM Oracle Agent Summaries.
Users:	This level displays Users information of Oracle Instance for the SRM Oracle Agent's client computer(s). Users associated with the Instance are populated under this level after completion of the first Data Collection operation. For more information, see SRM Oracle Agent Summaries.

Configuration Considerations

Consider the following configuration requirements prior to using the SRM Oracle Agent:

• For Oracle Databases running on Windows platforms, the SRM Oracle Agent can be installed directly on the computer running the Oracle Database or can function as a proxy Agent and be installed on a separate computer; in either event, the computer it is installed on must be running one of the operating systems listed in System Requirements - SRM Oracle Agent.
• For Oracle Databases running on UNIX platforms, the SRM Oracle Agent functions as a proxy Agent and must be installed on a separate computer running one of the proxy Agent operating systems listed in System Requirements - SRM Oracle Agent.
• Logical/physical device mapping for Oracle databases will only be accurate after you have run data collection jobs using both the SRM Agent for the Oracle Database and the SRM Windows File System Agent.
• The logical/physical mapping of Oracle databases on UNIX raw volumes or with ASM (Automatic Storage Management) will be reported only by Windows and Red Hat Linux.
• See Best Practices for Oracle to ensure that everything is set up properly before running Data Collection jobs for this agent.
• See Oracle logical/physical device view not working to identify and avoid common configuration issues.

License Requirement

To perform a data collection operation using this Agent, you need a SRM Oracle Agent license, available in the SRM server. The license is consumed when this component is configured on the client computer. See License Administration for more details on license requirements.

Back to Top