Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_LANG client set to AL32UTF8 and abnormal select performance issue

399831Oct 26 2009 — edited Sep 8 2010

Hi,
I use a simple select statement via sqlplus and noticed when changing the NLS_LANG from WE8ISO8859P15 to AL32UTF8 the query runtime is 10x longer.

DB: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
NLS_CHARACTERSET: AL32UTF8

The table has 500.000 rows and some varchar2(32), number(10) and date columns.

The select statement has no where conditions and looks like:

select a, b, c, a_date, b_date, c_date from x

The NLS_LANG for the OCI client is the only change before I connect the instance via sqlplus to perform the query.

The runtime is abnormal and I have no idea since the client and server charset are both AL32UTF8 and normally no conversion should happen.

Many thanks in advance for a clue.

Best regards,
Andreas

This post has been answered by oradba on Oct 28 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2010

Added on Oct 26 2009

#database-key-features, #globalization-support, #performance, #sql

9 comments

19,725 views