Oracle Database Monitoring

Analyze your database performance, usage, and availability at scale to enhance resource efficiency and optimize end-user experience problems.

Start 30-day free trial Try now, sign up in 30 seconds

Oracle is an object-relational database management system primarily designed for enterprise grid computing. It manages information, applications and provides logical data storage using tablespaces.

Monitoring its performance is essential to oversee database health and quickly identify and fix problematic servers and resource areas.

  • Know the memory and disk space metrics to make sure your Oracle DB processes have enough resources available.
  • Monitor response time and find out if there's any service suffering from bad database response times.
  • Know if the tablespaces are full and whether they require appropriate action to increase their capacity.
  • Track the number of Oracle sessions to know how busy a server is and ensure their continued functioning.

This document details the monitoring metrics to ensure continued performance and the steps to install the plugin .

Key Performance Monitoring Metrics

Session Count

The Session Count metric displays the total number of sessions.

Average Active Sessions

The Average Active Sessions metric denotes the number of sessions on the database that are either working or waiting for a resource at a specific point in time.

Logons per Sec

The Logons per Sec metric denotes the number of user logons per second during the sample period.

Shared Pool Free %

The Shared Pool Free % metrics shows the percentage of free space in the shared pool.

Buffer Cache Hit Ratio

The Buffer Cache Hit Ratio metric shows the percentage of pages found in the buffer cache without having to read from disk.

Long Running Query

The Long Running Query metric displays the count of long-running queries in the database.

To view the list of all metrics from our set of Oracle plugin integrations, visit our GitHub repository.

Get Started

Monitor your Oracle database with a set of seven plugins. Based on your requirement, install one or more of the plugins listed below:

Prerequisites

  • Download and install the Site24x7 server monitoring agent (Linux | Windows) in the server where you plan to run the plugin.
  • Ensure that you have Python 3.7 or a higher version installed in the server.
  • Grant the following roles to the user:
    grant select_catalog_role to {username}
    grant create session to {username}

Plugin Installation

  • Based on the plugins you plan to use, create a folder with distinct names as mentioned below.
    Then download the following files from our GitHub repository and place them in the appropriate new folder. Ensure that the name of the respective .py and .cfg files are identical to name of the folder you place it in.
  • Install the oracledb Python module using the command below:
    pip3 install oracledb
  • To check if the plugin is working, execute a command with appropriate arguments and see if the script returns a valid JSON output with applicable metrics and their corresponding value.
    For example, execute the below command for the OracleCore plugin:
    python3 OracleCore.py --hostname=<name of the host> --port=<port> --sid=<SID> --username=<USERNAME> --password=<PASSWORD> --oracle_home=<ORACLE_HOME>
    To check the other Oracle plugins, view the exact command for each plugin from our documentation for the respective Oracle plugin in our GitHub repository.
  • Add the appropriate configuration details in the .cfg file for the respective plugin.
    For example, for Oracle Core monitoring, the OracleCore.cfg file looks like the below:
    hostname=localhost
    port=1521
    sid=<SID>
    username=<USERNAME>
    password=<PASSWORD>
    logs_enabled="False"
    log_type_name =None
    log_file_path=None
    oracle_home=<oracle_home>
  • Follow the steps in this article to learn how to run the python script on a Windows server. You don't need to do this for Linux.
  • Move the respective Oracle plugin folder to the Site24x7 server monitoring plugins directory.

    For Linux: /opt/site24x7/monagent/plugins/

    For Windows: C:\Program Files (x86)\Site24x7\WinAgent\monitoring\plugins\

    For example, if you are installing the Oracle Core monitoring plugin, move the OracleCore folder to the aforementioned directory.
The agent will automatically execute the plugin within five minutes and display performance data in Site24x7.
To view the plugin monitor and associated performance charts:
  • Log in to Site24x7.
  • Navigate to Plugins and click the required monitor.

Plugin Contribution

Feel free to contribute to our existing plugin and come up with suggestions or feedback on our Community.

Other Plugin Integrations

  • Out-of-the-box plugins - Monitor your entire app stack with our extensive list of integrations
  • NGINX and NGINX Plus - Stay ahead of issues occuring within NGINX as well as anywhere else in your web infrastructure
  • MySQL - Monitor performance metrics of your MySQL databases
  • Postgres - Proactively monitor the availability and performance of business-crtical Postgres database server
  • Nagios - Execute thousands of Nagios plugins in Site24x7 without the need of running a Nagios server
  • Custom Script Monitoring - Create custom Linux and Windows plugins and monitor attributes that you need
  • GitHub Repository - Check out our 50+ plugin integrations

Troubleshooting tips: