UIM Oracle database operations are slow when using a database client/management tool

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

If you are performing database operations against an Oracle Database using an external Oracle client (such as Toad, Navicat, or SQLDeveloper), you may find that the

performance seems unreasonably slow.

 

This may be due to a mismatch in certain variables on our indexes.

 

Environment

UIM 20.x

Resolution

You can issue the following two commands in an Oracle client prior to doing any DB operations, and it may speed things up:

 

ALTER SESSION SET NLS_SORT = 'BINARY';

ALTER SESSION SET NLS_COMP = 'BINARY';

 

Additional Information

This will NOT work via the SLM Portlet in UMP or the SLM Client; you must use an external Oracle client that will issue these commands within the same login session as

any subsequent queries.

 

Please first check with your Oracle DBA before executing these commands.