Optimizations possible of an Oracle 8.0.5 DB ?

From: Ziegler Thomas <t.ziegler_at_ifrance.com>
Date: Thu, 26 Apr 2001 17:19:03 +0200
Message-ID: <9c9dqq$2fc3$1@spartacus.freesurf.fr>

Hi all,

Here's my pb :
computer1 : Winnt 2000 pro, Oracle 8.1.6 server ( On a PIII 600 Mhz with 256 MbRam),
computer2 : WinNT4.0 server, Oracle 8.0.5 server ( On a bi-pentium pro 400 Mhz with 398 MbRam)
computer3: IIS 5.0, JRun 2.x

When computer3 accesses to computer1 through a "JDBC thin" connection I have some quite good delays ( say about 5 sec. for my 50 requests). When computer3 accesses to computer2 through the same kind of connections I have a very long delay until I get the results of my same 50 requests. (about 50 sec.)
I use the classes111.zip file to access to computer1 and 2 . My base weigths about 150 Mb .

To my questions :
- are there some known performance enhancements between Oracle 8.0.5 and
Oracle 8.1.6 (I guess yes but not so much ...) ?
- what should I consider for optimizing Oracle 8.0.5 for a remote JDBC
access ?

Thanxs for any reply,
Thomas. Received on Thu Apr 26 2001 - 10:19:03 CDT