Tuning pack when application alters nls settings at logon
Date: Wed, 19 Sep 2018 13:35:55 -0400
Message-Id: <5BA288FB0200000B00048429_at_groupwise2014.gcrta.org>
We have an application that alters nls settings at connection time. Indexes on character columns are built with these revised nls settings. If we do an explain plan without setting the applicable nls settings, indexes are not used. The indexes are only selected by the explain plan if an alter session is first done to set the application settings. My question is, we use EM 13C with the diagnostic and tuning packs. How can we make EM 13C use the correct nls settings before running the tuning advisor? The nls settings dynamically set are:
alter session set nls_comp = LINGUISTIC;
alter session set NLS_SORT = PUNCTUATION;
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 19 2018 - 19:35:55 CEST