[Oracle-l] UTF8 Vs. WE1252 performance

We're running a 3-node RAC with AL32UTF8 as the characterset and we experience no performance issues related to the character set definition.

David Fitzjarrell


From: Raju Angani <[email protected]>
To: [email protected]
Sent: Wednesday, September 28, 2011 4:41 PM
Subject: UTF8 Vs. WE1252 performance

Hi Oracle gurus,

Firstly, big thanks to Kyle, Mark & Jared for taking care of the post
privilege issue.

Jumping straight at the performance question, currently on one of the
applications, I'm using WE8MSWIN1252 characterset and using 916
NVARCHAR2 columns of the total 2880 columns in the schema(282 tables).
I'm recommending to create the DB with UTF8 characerset and switch all
916 NVARCHAR2 to VARCAR2 within the schema and expand the column
length to accommidate the multibyte characters, to take care of
truncation issues with CS change.

Question: What would be the performance impact(good/bad)?
Using utf8 in the past, performance was slightly low when doing string
comparison.

Could you please share your experience or any pointers.

Thank you
Raju