Introduction

An Oracle database server consists of many different components. These include internal memory structures, processes that execute the database server’s tasks, the physical structures that include resources for storing application data and special resources that are designed to allow for recovering data from problems ranging from incorrect entry to disk failure. All three structures of the Oracle database server running together to allow users to read and modify data are referred to as an Oracle instance. Figure 1 demonstrates the various memory, process, and physical storage components of a typical Oracle instance.

Figure 1 : Architecture of an Oracle database server

The eG Enterprise Oracle Monitor includes extensive monitoring capabilities for Oracle databases. A single eG agent is capable of monitoring all of the Oracle database instances being executed on a system. Monitoring of the Oracle database instances is performed non-intrusively, with administrators having the option of configuring whether the monitoring is to be performed in an agent-based or agentless manner. eG Enterprise’s 100% web-based architecture, allows geographically distributed database servers to be managed from a central manager. Administrators can view and analyze the performance of their database servers in real-time over the web. To avoid overwhelming the administrator with a ton of performance data, the eG Oracle Monitor includes a specialized model for an Oracle database server. By viewing the layer model of a database server, an administrator can quickly determine which layer(s) of the database server is causing a problem.