Knowledge Base

Using Database Query Analysis

KB1239 - Aug 02, 2018

Type: Best Practice

Description: Monitoring Studio provides a flexible feature to query data from any database. You can for example query an Oracle database using its name or its service name.

Additional Keywords: Database Query, Oracle

Related Topics

Introduction

Monitoring Studio provides a flexible feature to query data from any database. In this article, you will learn how to query a database using its name or its service name. The example is based on an Oracle database.

Procedure

Configuring Using the Database Name

To query an Oracle database using its name:

  1. Right-click the monitored host and click KM Commands > New > Monitor
  2. Select the Database Query: Oracle Data Server Monitor

    Selecting the "Database Query: Oracle Database Server" Monitor

  3. Provide the Database name and Port number and click Next

    Providing the Database name and Port number

  4. Provide the Credentials to connect to the database, the SQL query to be executed and click Next

    Entering the Database Server Connection Information

  5. Configure the Monitor Settings and click Next

    Configuring the Monitor Settings

Configuring Using the Service Name

To query an Oracle database using the service name:

  1. Right-click the monitored host and click KM Commands > New > Monitor
  2. Select the Database Query: Other (JDBC) Monitor

    Selecting the "Database Query: Other (JDBC)" Monitor

  3. Enter the URL to use for connecting to the JDBC database. The format to use is: jdbc:oracle:thin@<hostname>:<port>/<ServiceName>

    Providing the JDBC Connection Information

    You can use application constants to replace for the <hostname> if you are planning to save your configuration as a template.

    You can refer to the article How to find Oracle Service Name
  4. Provide the Credentials to connect to the database, the SQL query to be executed and click Next

    Providing the JDBC Query Information

  5. Configure the Monitor Settings and click Next

    Entering the Database Server Connection Information