Re: Optimizations possible of an Oracle 8.0.5 DB ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 26 Apr 2001 18:59:02 +0200
Message-ID: <ehkgetgj5hrchuc2b0mtddorldrkpuniaa@4ax.com>

The classes are a java thingy and have zilch to do with sqlnet. You can't do much to benchmark sqlnet access. I use three tricks myself
0 I tnsping the server. You will be shown how long the ping took. 1 issue
alter session set events = '10046 trace name context forever, level 8' in a sqlplus session before doing anything. This will generate a trace file on the server, with an exact breakdown of where it is waiting for, including sqlnet. 2 run a full sqlnet trace, by including the following in sqlnet.ora

trace_level_client = 16
trace_unique_client = true
trace_directory_client = <any sensible directory>

This will generate a cli<n>.trc on the client, with dumps of all the sqlnet packages transmitted.
Most likely you are underutilizing sqlnet (the default packet size is 2048), or you are fragmenting your sqlnet packets (the maximum transmission unit of ethernet is 1500 bytes, so a 2048 byte packet will be fragmented)
This can be prevented by setting the SDU to a multiple of the MTU. Before I explain how to do this, you probably should get some data first.

Regards,

Sybrand Bakker, Oracle DBA

On Thu, 26 Apr 2001 18:03:18 +0200, "Ziegler Thomas" <t.ziegler_at_ifrance.com> wrote:

>Ok I see ...
>Although I'm a bit surprised of what you've said about Sqlnet ...
>I thought It could possibly come from an inadequate version of the
>classes...
>
>I don't think it is a network pb . Both configurations are on the same
>network and have the same transfer speed ...
>But I will look a bit deeper into it....
>
>Are there some tools I could use for benchmarking Sqlnet accesses ?
>
>Thanx a lot for your response.
>Thomas.
>
>
>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message news:
>teggdin76il1f_at_beta-news.demon.nl...
>> 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.
>> >
>> >
>>
>>
>

Sybrand Bakker, Oracle DBA Received on Thu Apr 26 2001 - 11:59:02 CDT