URGENT: Slow Performance after migration to 9.2.0.3 from 8.1.7

From: Dan Yusuph <oradba_at_mail.kz>
Date: Sat, 6 Sep 2003 14:25:39 +0600
Message-ID: <bjc3oc$hk4qj$1@ID-175901.news.uni-berlin.de>

Alex Vilner" <alex_at_sinoma.com>
wrote in message news:22e9f6e0.0309051933.2a258684_at_posting.google.com...

AV> We are having significant performance degradation (10 to 100 times) in
AV> the execution of the queries on the Oracle 9i server, after migrating
AV> the database from 8i to 9i. 9i has been installed on a new machine
AV> (not an upgrade, 9.2 & Patch Set 2), database dump loaded, statistics
AV> computed anew... The servers are Windows 2000 & Solaris, drop in
AV> performance is experienced on both 9i environments....

how did you converted your init.ora from 8.1.7 to 9.2 ? there are some parameters has been changed their default values for example db_block_checksum is true by default in 9.2 if you didn't specified it in your pfile it may slow down relatively

Dan Received on Sat Sep 06 2003 - 03:25:39 CDT