Re: drop in sql plus query performance from 7.3.4 to 8i

The server is an Oracle 8i server.
[Quoted] Any thoughts on how I could trouble shoot this?

Thanks
Jeff

On Thu, 4 Oct 2001 19:35:52 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"Jeff Kish" <jeff.kish_at_ait-mmii.com> wrote in message
>news:parorts0mfkmtf4q7gkuscoompse50gka8_at_4ax.com...
>> Greetings.
>>
>> I am finding that with a simple select * from table
>> on an nt 4.0 workstation, if I have oracle 7.3.4 client installed, it
>> runs 3x faster (against the same NT Oracle 8i database) than it runs
>> if I upgrade JUST the oracle client software to 8.1.6.
>>
>>
>> Any suggestions on troubleshooting this, or fixing the performance
>> drop? This is causing much sadness at my customers site.
>> thanks
>> Jeff Kish
>>
>
>Which version of the database?
>While sqlnet 2 can talk to net8, and net8 seems to be talking to sqlnet2
>they changed fundamentally the messaging between client and server in net 8.
>There might be some sort of conversion going on.
>
>Hth,
>
>Sybrand Bakker, Senior Oracle DBA
>
>
Received on Tue Oct 09 2001 - 13:54:39 CEST