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

book

Article ID: 33651

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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.
 

Instructions:

 

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.
 

Environment

Release:
Component: CAUIM