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

Document ID : KB000033651
Last Modified Date : 14/02/2018
Show Technical Document Details
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.