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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


migration rejected from Jun 2 '15 at 8:57

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Max Vernon, Paul White, RolandoMySQLDBA, Colin 't Hart, dezso Jun 2 '15 at 8:57

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

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