Templates: Database Servers – Oracle Database Server on Windows host

Monitors included into Database Servers – Oracle Database Server on Windows host template

Monitors from this application template check availability and performance data of an Oracle Database Server on a Windows host. Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation. The server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. The server also prevents unauthorized access and provides efficient solutions for failure recovery. More about templates.

Monitors list

Monitors description

Oracle Service (enabled by default) Shows if Oracle Service is alive.

Oracle port (enabled by default) Shows if the server answers on specified port. Default is 1521.

Test DB record count (enabled by default) Test SQL query. You can replace the sample query with any suitable query that can indicate the database health.

Available free memory, MB Memory available for DB operations. Shows you the amount of memory (in megabytes) that are free on the application server host. The amount of free memory available can help you determine whether or not the system is ready to handle a heavier load.

Available free space, MB Free space available for DB operations. Requires SELECT_CATALOG_ROLE.

Buffer cache hit ratio, % This metric represents the data block buffer cache efficiency, as measured by the percentage of times the data block requested by the query is in memory. Effective use of the buffer cache can greatly reduce the I/O load on the database. If the buffer cache is too small, frequently accessed data will be flushed from the buffer cache too quickly which forces the information to be re-fetched from disk. Since disk access is much slower than memory access, application performance will suffer. In addition, the extra burden imposed on the I/O subsystem could introduce a bottleneck at one or more devices that would further degrade performance.

Connected users Connected users count.

Data files size, MB Data files size, MB. Requires SELECT_CATALOG_ROLE.

Dictionary cache hit ratio, % Dictionary cache hit ratio, %. This metric represents dictionary cache efficiency as measured by the percentage of requests against the dictionary data that were already in memory. It is important to determine whether the misses on the data dictionary are actually affecting the performance of the Oracle Server.

Library cache hit ratio, % Library cache hit ratio, %. This metric represents the library cache efficiency, as measured by the percentage of times the fully parsed or compiled representation of PL/SQL blocks and SQL statements are already in memory.

Oracle NetListener Service Shows if Oracle NetListener Service is alive. Oracle Net Listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server. This chapter describes how to configure the listener to accept client connections.

Temp files size, MB Temp files size, MB. Temp files are a special class of data files that are associated only with temporary tablespaces.

User rollbacks User rollbacks count. This  metric statistic stores the number of times users manually issue the ROLLBACK statement or an error occurs during users’ transactions.

User transactions User transactions count. Represents the total number of commits and rollbacks performed.

Web Admin Shows if Web Admin accepts connections on specified port. Default is 8080.

Templates overview

IPHost Network Monitor provides application templates (or just “templates” later in document), to create multiple relevant monitors in only a few clicks. Templates facilitate adding typical monitors sets; this can be particularly useful in case of big networks, when creating same-type monitors for many same-type devices is a common task. Application templates are sets of monitors that can be added, using specific predefined parameters, for a given host at once. The said set, added for given host, is displayed as a separate node in tree view pane, and is named application.

There are predefined templates; user can as well generate templates of their own – either out of existing monitors, or by cloning a predefined template. User-added template definitions are saved in XML files and can thus be conveniently augmented or applied to specific needs.