Another thing you need to check on is the optimization method. If you were
using the rule based optimizer in 7, and are using cost optimization in 8,
there might be some tuning activities required. If you have access to a
product called SQL*Navigator with the SQL*Tuner package, it will tell you if
indexes are required to assist the optimizer. Also, you need to analyze the
tables. You can look for sql statements in sqlarea with poor hit ratios,
and identify which statements need help.
--
Richard Armstrong
State Of The Art Consulting, Inc.
http://www.stateoart.com
cz <zhangc_at_netcom.ca> wrote in message
news:7i1lhi$ago$1_at_clio.net.metrotor.on.ca...
> We just migrated our Oracle server from 7.3.4 to 8.0.5 for one of our
> application with fat client built by PowerBuilder and we encounted an
> EXTREMELY slow performance problem. What could it be?
>
>
Received on Fri May 21 1999 - 16:18:38 CDT
