ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Oracle database operations are slow when using a database client/management tool
Article ID: 33651
DX Unified Infrastructure Management (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
performance seems unreasonably slow.
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.