The Oracle Database Extended agent supports local monitoring and remote monitoring.
Feature | Local | Remote |
---|---|---|
Installation on Oracle Server computer | Yes | No |
Oracle physical disk usage monitoring | Yes | Not supported |
Oracle alert log monitoring | Yes | Yes, requires mounting the log directory for the remote computer to a local computer, and requires specifying the mount path at agent configuration. |
Other monitoring features | Yes | Yes |
Maintenance effort | A large effort requires applying an agent patch on each Oracle server computer. | A small effort requires applying a patch on the computer on which the agent is installed one time. |
The best practice involves considering the number of agent instances and database connections on one system. 10 agent instances times five database connections (monitoring 50 databases on one system) is optimal. The performance of the agent depends on system performance, network performance, and most importantly the number of data requests, including situation and historical data collection. With fewer data requests for one database, more databases can be monitored on one system. As a best practice, first configure 10 agent instances times five database connections, and observe performance, such as the length of the response time for the data request. If the performance is acceptable, you can consider monitoring more databases on the system; if not acceptable, set up another system with the Oracle Database Extended agent installed.