Re: Optimizations possible of an Oracle 8.0.5 DB ?

8.0.5 has been desupported and there have been significant performance enhancements in 8i.
You need to upgrade 8.0.6 anyway, but I would suggest you first try to isolate it is a network problem.
Sqlnet is sqlnet is sqlnet, it works or it doesn't work, and delays are very unlikely.

Regards,

Sybrand Bakker, Oracle DBA

"Ziegler Thomas" <t.ziegler_at_ifrance.com> wrote in message news:9c9dqq$2fc3$1_at_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:43:46 CDT