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