Re: Optimizations possible of an Oracle 8.0.5 DB ?

Sybrand Bakker wrote:

> The classes are a java thingy and have zilch to do with sqlnet.

Doesnt classes dictate what kind of communication stack NET8 uses? Especially with JDBC thin layer... (I might think somehow 8.0.6 uses an inefficient stack)

Agreed with rest of the stuff , but one has to keep in mind that traditional NET8/sqlnet is not used in a JDBC thin connection.

> 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.
>>>> 
>>>> 
>>> 
>>>