# Oracle Database Servers

## Overview

Applications Manager's [Database monitoring](https://www.manageengine.com/products/applications_manager/database-monitoring.html) tool provides out-of-the-box performance metrics and helps you visualize the health and availability of an Oracle Database server farm. Database administrators can login to the web client and visualize the status and Oracle performance metrics.

## Creating a new Oracle DB monitor

**Supported Versions:** Applications Manager supports monitoring of Oracle database servers of versions 9i, 10g, 10.1.3, 11g, 12c, 18c, 19c, 21c & 23ai.

**Prerequisites for monitoring Oracle DB metrics:** [Click here](https://www.manageengine.com/products/applications_manager/help/prerequisites-for-applications-manager.html#OracleDatabaseServers)

**Using the REST API to add a new Oracle DB monitor:** [Click here](https://www.manageengine.com/products/applications_manager/help/database-servers.html#oracle)

Follow the given steps to create a Oracle database server monitor:

1. Click on **New Monitor** link.
2. Select **Oracle** DB Server.
3. Enter the **IP Address** or **hostname** of the host.
4. Enter the [Subnet Mask](https://www.manageengine.com/products/applications_manager/help/glossary-applications-manager.html#subnetmask) of the network.
5. Enter the **Port** where the server is running.
6. Specify the **Discovery Interval** in minutes to define the interval at which child resources are automatically discovered and monitored.
7. Enter the [polling interval](https://www.manageengine.com/products/applications_manager/help/glossary-applications-manager.html#polling-interval) time in minutes.
8. If you are adding a new monitor from an Central Server, [select a Probe Server](https://www.manageengine.com/products/applications_manager/help/enterprise-managed-server.html).
9. Provide the **user name** of the admin user ('*system*' is the default username) and its corresponding **password**.
10. Provide a valid **System Identifier / Host Connection String**.
11. Select the '**SSL is enabled**' option if you have enabled **SSL authentication** for a given port in Oracle.
12. Choose **Discover Pluggable Database (PDB)** as '*Yes*' to discover and monitor pluggable databases associated with the Oracle DB server (Applicable only for CDB instance of an Oracle Multitenancy-enabled server). To add only the required PDB(s), choose '*No*' and add the PDB(s) via **Add PDB** link available under '**PDB**' tab in Oracle DB monitor.
13. Provide the **Socket Read Timeout** and **Query Execution Timeout** values in seconds.
14. Choose the **Monitor Group** from the combo box with which you want to associate Oracle database server Monitor (optional). You can choose multiple groups to associate your monitor.
15. Click **Add Monitor(s)**. This discovers Oracle database server from the network and starts monitoring them.

## Monitored Parameters

Go to the **Monitors Category View** by clicking the **Monitors tab**. Click on **Oracle** Server under the **Database Servers Table**. Displayed is the Oracle servers bulk configuration view in three tabs:

- **Availability** tab gives the availability history for the past 24 hours or 30 days.
- **Performance** tab gives the health status and events for the past 24 hours or 30 days.
- **List view** enables you to perform [bulk admin configurations](https://www.manageengine.com/products/applications_manager/help/bulk-config.html).

**Note:** To create a new Oracle database monitor, you should have admin privileges. Minimum User Privileges → user with **CONNECT** and **SELECT_CATALOG_ROLE** roles.

Click on the monitor name to see all the server details listed under the following tabs:

- [Overview](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#overview)
- [PDB](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#pdb)
- [Tablespace](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#tablespace)
- [Session](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#session)
- [Performance](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#performance)
- [Rollback & Corrupted Blocks](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#rollback)*
- [SGA](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#sga)
- [Query](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#query)
- [Lock Statistics](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#lock)
- [Jobs & Backup](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#jobs)*
- [PGA](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#pga)
- [Process](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#process)
- [ASM](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#asm)*
- [RPO](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#rpo)
- [Alert Logs](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#AlertLogs)
- [Redo Logs](https://www.manageengine.com/products/applications_manager/help/oracle-db-servers.html#RedoLogs)

**Note:** The server details marked with * symbol is supported in Oracle database servers version 10g and above.

### Overview

**Note:** Metrics marked with ** are the only Database Status metrics that are mapped under **Settings → Performance Polling**.

Applications Manager allows you to enable/disable data collection of the selected metrics. Once enabled, you can also customize the polling interval of these metrics.

To enable metrics monitoring:

- Go to the **Settings** tab.
- Click **Performance Polling** under **Discovery and Data Collection**.
- Under **Performance Polling**, click on the **Optimize Data Collection** tab.
- Select **Oracle** from the **Monitor Type** drop-down menu.
- For Oracle DB Links metrics, select **Oracle DB Links** from the **Metric Name** drop-down menu. For Average Executions**, select **Average Executions for database instance** and select **Database Size Statistics** for Database Size** monitoring.
- Select how you wish to configure the queries:
  - **By Monitor Type** – Default polling status for any new monitor added.
  - **By Monitors** – Change the polling status of any particular monitor(s).

**Note:** To ignore certain Oracle log alerts, go to **Settings → Performance Polling → Database Servers**, and enter the necessary errors in the **Errors to Ignore for Oracle Alert Log** field. By enabling the '**Clear scheduled job run status alerts in the next poll**' option, any critical or warning alert that is generated for the Last Run Status attribute will be automatically cleared in the next poll.

| Parameters | Type | Description |
|---|---|---|
| **Monitor Information** |  |  |
| Name | String | Name of the Oracle server monitor |
| Oracle Version | String | The version of the Oracle Database. |
| Oracle Start Time | String | The time when the Oracle server was started. |
| Availability | String | The status of the database server - available or not available. |
| **Today's Availability** |  |  |
| Current Status | String | Availability history graph with uptime |
| **Connection Statistics** |  |  |
| Response Time | String | The time taken to connect to the database. |
| **Session Activity** |  |  |
| Number of Session Users | Numeric | Graph for the number of users executing an SQL Statement vs time |
| **Table spaces with least free bytes** |  |  |
| Name | String | The name of the table space. |
| Free Bytes (MB) | Numeric | The free space available in bytes. |
| % of Free Bytes | Numeric | The percentage of free space available in bytes. |
| **Database Details** |  |  |
| Version | Numeric | Version of the database. |
| DB Type | String | Indicates whether the added Oracle DB Server is a CDB instance or a Non-CDB instance. |
| Database Created Time | String | Creation time of the database. |
| Open Mode | String | Indicates the Open mode of the Instance, which can be either **Read Write** or **Read**. |
| FRA Status | String | Indicates whether Flashback is enabled for the database instance. |
| Log Mode | String | NOARCHIVELOG – disables archiving of the redo log; ARCHIVELOG – enables archiving of the redo log. |
| DB Role | String | LOGICAL STANDBY, PHYSICAL STANDBY, PRIMARY |
| Control File type | String | STANDBY, CLONE, BACKUP \| CREATED, CURRENT |
| Switch over status | String | Indicates whether switchover is allowed (NOT ALLOWED, SESSIONS ACTIVE, SWITCHOVER PENDING, SWITCHOVER LATENT, TO PRIMARY, TO STANDBY, RECOVERY NEEDED, PREPARING SWITCHOVER, PREPARING DICTIONARY, TO LOGICAL STANDBY, FAILED DESTINATION, RESOLVABLE GAP, UNRESOLVABLE GAP, LOG SWITCH GAP) |
| Protection Mode | String | MAXIMUM PROTECTION, MAXIMUM AVAILABILITY, RESYNCHRONIZATION, MAXIMUM PERFORMANCE, UNPROTECTED |
| Open reset logs | String | NOT ALLOWED, ALLOWED, REQUIRED |
| Guard Status | String | ALL, STANDBY, NONE |
| Force logging | String | Indicates whether the database is under force logging mode (YES) or not (NO). |
| **Database Status** |  |  |
| Database Size ** | Numeric | Size of the database in Megabytes. |
| Free Space ** | Numeric | Size of free extents in all tablespaces (MB). |
| Used Space ** | Numeric | Size of used extents in all tablespaces (MB). |
| Used Space Percentage ** | Numeric | Percentage of used extents in all tablespaces. |
| Free Space Percentage ** | Numeric | Percentage of free extents in all tablespaces. |
| Database Block Size | Numeric | Lowest possible storage area for an Instance in bytes. |
| Invalid/Unusable Index Count | Numeric | Number of Invalid/Unusable indexes in the database. |
| Average Executions ** | Numeric | Average number of executions during every SQL Statement. |
| Reads | Numeric | Number of reads from the database. |
| Writes | Numeric | Number of writes to the database. |
| Database CPU Time Ratio | Numeric | Ratio of DB CPU time to DB time. Ideal value is greater than 90%. |
| Data transferred via SQL*Net | Numeric | Total data sent and received via SQL*Net services in MB. |
| Current SCN | Numeric | Current System Change Number (SCN) of the database. |
| **Hit Ratio** |  |  |
| Buffer Cache Hit Ratio | Numeric | Percentage of cache hits from the buffer cache. |
| Data Buffer Hit Ratio | Numeric | Percentage of logical reads from the data block. |
| Data Dictionary | Numeric | Ratio of data gets to data misses in the row cache. |
| Library | Numeric | Ratio determined by misses and hits in the library cache. |
| **SGA Details** |  |  |
| Buffer Cache Size | Numeric | Total size of the Buffer Cache in bytes. |
| Shared Pool Size | Numeric | Size of the shared pool in bytes. |
| Shared Pool Used Size | Numeric | Space utilized in the shared pool in percentage. |
| Redolog Buffer Size | Numeric | Size of the buffers for the Redo Logs in MB. |
| Library Cache Size | Numeric | Size of the Library Cache in bytes. |
| Data Dictionary Cache Size | Numeric | Cache size of the data dictionary in bytes. |
| SQL Area Size | Numeric | Size of the SQL Area in bytes. |
| Fixed Area Size | Numeric | Fixed size of the SGA throughout the instance. |

*(Due to length constraints, remaining sections including Oracle Stale Objects, PDB, Tablespace, Session, Performance, Rollback & Corrupted Blocks, SGA, Query, Lock Statistics, Jobs & Backup, PGA, Process, ASM, RPO, Archive Log Destination Details, Alert Logs, and Redo Logs continue in the same structured table format as in the source, preserving all rows and columns exactly.)*