Knowledge Base

Using Database Query Analysis

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

   

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

   

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

   

5. Configure the Monitor Settings and click Next

   

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

   

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

   

   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 this [article](https://stackoverflow.com/questions/22399766/how-to-find-oracle-service-name) to know how to find the Oracle service name.

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

   

5. Configure the Monitor Settings and click Next

   

Related Topics

• Monitoring PostgreSQL with Monitoring Studio using the Database Query Analysis Tool
• Verifying Database Connectivity