Tuning Advisor with NLS settings

From: Jeffrey Beckstrom <jbeckstrom_at_gcrta.org>
Date: Tue, 28 Aug 2018 14:12:32 -0400
Message-Id: <5B8590900200000B00046946_at_groupwise2014.gcrta.org>





We license the Diagnostic and Tuning Pack and run them via EM 12C and 13C. We have one database that uses the following settings at logon time of the application. alter session set nls_comp = LINGUISTIC; alter session set NLS_SORT = PUNCTUATION;

How can we tell EM to use these settings prior to running the tuning advisor on a SQL statement?

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 Tue Aug 28 2018 - 20:12:32 CEST

Original text of this message