Oracle database operations are slow when using a database client/management tool
CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
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
This may be due to a mismatch in certain variables on our indexes.
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';
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.