> ## Documentation Index
> Fetch the complete documentation index at: https://docs.germainux.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Configure Monitoring for Oracle Database

> Monitor the usage and growth of tablespaces and datafiles within the Oracle database.

Components
[`Engine`](/main/germain-ux-engine)

Availability
2014.1 or later

> **[Monitor tablespaces and datafiles](#monitor-tablespaces-and-datafiles)**
>
> Track free space and growth

> **[Setup in Germain Workspace](#setup-in-germain-workspace)**
>
> Start the Oracle wizard

> **[Add DB Credentials](#add-db-credentials)**
>
> Store the database login

> **[Enter Database details](#enter-database-details)**
>
> Connection details for the database

## Monitor tablespaces and datafiles

Monitor the usage and growth of tablespaces and datafiles within the Oracle database. Track free space, growth rate, and ensure that tablespaces are properly managed to prevent space-related issues.

For basic monitoring of a single instance, Germain uses a regular database user account with CONNECT permissions. In the case of Oracle RAC, it is possible to monitor the status of the cluster as a whole or individual instances. To perform more in-depth monitoring, the database user needs to be granted additional permissions to execute queries against a series of system views.

Please note that Germain can monitor any other Oracle tables, whether they are system tables or data tables. The requirements mentioned below are the bare minimum, but they can be extended to include monitoring of any other tables as well.

## Required Views and Permissions

| View (Single Instance) | View (Multi-Instance / RAC) | Permission |
| - | - | - |
| V\$SYSSTAT | GV\$SYSSTAT | SELECT |
| V\$SYSTEM\_EVENT | GV\$SYSTEM\_EVENT | SELECT |
| V\$SESSION | GV\$SESSION | SELECT |
| V\$SQL | GV\$SQL | SELECT |
| V\$SQLTEXT | GV\$SQLTEXT | SELECT |
| V\$SYSTEM\_PARAMETER | GV\$SYSTEM\_PARAMETER | SELECT |
| V\$RESOURCE\_LIMIT | GV\$RESOURCE\_LIMIT | SELECT |
| V\$SQLSTATS | GV\$SQLSTATS | SELECT |
| V\$SESSTAT | GV\$SESSTAT | SELECT |
| V\$STATNAME | GV\$STATNAME | SELECT |
| V\$DIAG\_ALERT\_EXT | GV\$DIAG\_ALERT\_EXT | SELECT |
| V\$LOCKED\_OBJECT | GV\$LOCKED\_OBJECT | SELECT |
| V\$LOG | V\$LOG | SELECT |
| V\$RECOVERY\_FILE\_DEST | V\$RECOVERY\_FILE\_DEST | SELECT |
| DBA\_DATA\_FILES | DBA\_DATA\_FILES | SELECT |
| DBA\_TABLESPACE\_USAGE\_METRICS | DBA\_TABLESPACE\_USAGE\_METRICS | SELECT |
| DBA\_TEMP\_FILES | DBA\_TEMP\_FILES | SELECT |
| DBA\_TEMP\_FREE\_SPACE | DBA\_TEMP\_FREE\_SPACE | SELECT |

## Setup in Germain Workspace

Log on to Germain Workspace > left menu > Wizards > **Oracle Database Server**

![Configure Monitoring for Oracle Database: Setup in Germain Workspace](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image2023-2-21_10-54-59.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=d88511bc45a5cc642f7033b6612ffa44)

## Add Database as Data Source

Germain workspace > Left Menu > Data Sources > Database > Add New Configuration

![Configure Monitoring for Oracle Database: Add Database as Data Source](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20230221-140419.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=e84c80e2dc26930c03be38ca3a2dbdca)

## Add DB Credentials

Germain Workspace > Left Menu > Data Sources > Credentials

![Configure Monitoring for Oracle Database: Add DB Credentials](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20230221-140323.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=b0aef6568dcebdc82a6920f3d68b5960)

## Add Database Query Monitor

Germain Workspace > Left Menu > Wizards > Database Query Monitor Deployment

![Configure Monitoring for Oracle Database: Add Database Query Monitor](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20230221-140532.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=3e4e8d38a4169014a433948b1a446ea8)

## Enter Database details

![Configure Monitoring for Oracle Database: Enter Database details](https://mintcdn.com/germain-ux/ZJflvRMC808oZDAs/images/main/configure-monitoring-for-oracle-database/image-20201105-174302.png?fit=max\&auto=format\&n=ZJflvRMC808oZDAs\&q=85\&s=5fde7b8fe2a6d102ae7d0f293784897f)

![Configure Monitoring for Oracle Database: Enter Database details, image 2](https://mintcdn.com/germain-ux/ZJflvRMC808oZDAs/images/main/configure-monitoring-for-oracle-database/image-20201105-174315.png?fit=max\&auto=format\&n=ZJflvRMC808oZDAs\&q=85\&s=c0ad9dc536ee0f67dbf43bf99cde175e)

![Configure Monitoring for Oracle Database: Enter Database details, image 3](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174332.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=d60897d91db6cb040c5c9b4bf7a2410a)

![Configure Monitoring for Oracle Database: Enter Database details, image 4](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174340.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=eb1eb37e32300931958a4603dd82dbe5)

### Add KPI

![Configure Monitoring for Oracle Database: Add KPI](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174347.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=cd373090ead5ed27220f1cefdbfdf60d)

![Configure Monitoring for Oracle Database: Add KPI, image 2](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174355.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=4c6c304b9323cf59a1b82703e5011cd0)

Create the base SLA for the new KPI. Choose Fact-based SLA

![Configure Monitoring for Oracle Database: Add KPI, image 3](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174404.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=b172551710755ae60bdb16e51e1bffc9)

### Add SLA

Alert Template: SLA. \
 Choose one or more of your actions (Alerts, Reports, Scripts, ect..)

![Configure Monitoring for Oracle Database: Add SLA](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174414.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=22bbb2429db474eff54b522c3a0c33df)

### Set KPI

![Configure Monitoring for Oracle Database: Set KPI](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174431.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=32222b6a36e235bfd0f10b5f1adde2f8)

![Configure Monitoring for Oracle Database: Set KPI, image 2](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174438.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=23982a8f2657564119be5e944d47d03c)

### Deployment details

Monitoring Node: The Node that the Engine runs from

Engine: The engine you want to run the Monitor on

Fill in the schedule you would like the Monitor to run on

![Configure Monitoring for Oracle Database: Deployment details](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174503.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=6d9116b5bd0248ea249386653618ec1b)

### Verify the Monitor

Verify the Monitor by finding in “Germain State”

![Configure Monitoring for Oracle Database: Verify the Monitor](https://mintcdn.com/germain-ux/npHkPTFCfiH3hzwe/images/main/configure-monitoring-for-oracle-database/image-20201105-174519.png?fit=max\&auto=format\&n=npHkPTFCfiH3hzwe\&q=85\&s=cd4a65b0ac976e0fc5bdde64921c6f24)

For more detailed information, please r[eaching out to us](/main/support.md). We will provide you with further guidance and assistance tailored to your needs.

## Get Help

> **[Contact GermainUX Support](/main/support.md)**
>
> The Germain Team can help you set this up.

> **Can't find what you need?**
>
> Search all GermainUX docs with **Ctrl + K**, or use the feedback buttons at the bottom of this page to tell us what is missing.

The content of this document is proprietary to GERMAIN SOFTWARE.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.