Re: drop in sql plus query performance from 7.3.4 to 8i
Date: Thu, 4 Oct 2001 19:35:52 +0200
Message-ID: <trp8bc176qro78_at_news.demon.nl>
[Quoted] "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.
[Quoted] There might be some sort of conversion going on.
Hth,
Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 04 2001 - 19:35:52 CEST