sql_response ORACLE ODBC connection intermittently fails

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

One of the connections intermittently fails and it also affect other connections. The profile has an ORACLE ODBC connection and all other similar profiles and connections work fine. 

Environment

• DX UIM 23.4.*
• sql_response 1.82

 

Cause

Custom query profile "cursor" configuration can affect the performance of the profile. 

 Cursor types are defined as follows:

sql_response IM Configuration

Server: allows you to create the cursor in the database server. This setting delivers realistic data about the database performance, but reduces performance when the net-traffic increases.

Client: allows you to transfer the record set to the client machine by ADO and manage the cursor there. This option provides better performance, but the results are buffered (depending on the ADO provider) and can hide actual database performance.

Resolution

If failing process is running Server Cursor type, turn the cursor configuration from Server to Client.