Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an Oracle database which runs on version 9.0.1 with WE8859P1 charset and i'm trying to migrate it to the version 9.2i which has the WE8MSWIN1252 charset. The conversion is made without any warnings but then the database becomes too slow! I tried to run many tests including analyze sentences but it gets fast just WHILE the analyze is running, after finishing it it turns to slow again.

Do you have any idea of how we could solve this problem?

share|improve this question

migrated from stackoverflow.com Mar 6 '13 at 8:00

This question came from our site for professional and enthusiast programmers.

What's the reason to upgrade to a non-supported version? –  a_horse_with_no_name Mar 6 '13 at 7:47
It's highly unlikely that changing charset is the reason for the drop in performance. Changing database version on the other hand modifies many things. We won't be able to help you unless you provide more details, for example a query with the execution plans and execution times before and after the migration. –  Vincent Malgrat Mar 6 '13 at 9:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.