Re: PB + Oracle 8.0.5 = Poor Performance
Date: Tue, 1 Dec 1998 15:28:49 +0100
Message-ID: <740tmf$6j0$1_at_news.worldonline.nl>
cjoe125_at_my-dejanews.com wrote in bericht
<73uj8e$fkj$1_at_nnrp1.dejanews.com>...
>Hi, colleagues!
> I recently installed Oracle 8.0.5.0.0 on Sun Enterprise Server 450 with
>Solaris 2.6 and moved data from Oracle 7.3.2.2.0 database on HP 9000 with
>HP-UX 2.0B. The new Sun Server is much more powerful. So, with sqlplus, I
>compared results from these two machines and found that queries ran much
>faster in Oracle8 in the Sun box than in the HP. However, when I tested
with
>application programs written by PowerBuilder, I got much poorer results
from
>Oracle 8 on Sun. The application ran at least ten times slower connecting
to
>Sun than to HP.
That sounds like an application problem.
Could it be the cost-based optimizer?
Did you do a "compute statistics" ?
Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife Received on Tue Dec 01 1998 - 15:28:49 CET