Tell me more ×
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.
up vote 0 down vote favorite

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
5  
What's the reason to upgrade to a non-supported version? – a_horse_with_no_name Mar 6 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 at 9:57

migrated from stackoverflow.com Mar 6 at 8:00

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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