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

[Quoted] Not when you continue not to provide *any* detail about your configuration, like *which* version of the server,
how you have determined the performance drop (sql trace should provide identical results, shouldn't it) etc, etc, etc.
I 'm not clairvoyant and I don't have a crystall ball here.

Regards,

Sybrand Bakker
Senior Oracle DBA

"Jeff Kish" <jeff.kish_at_ait-mmii.com> wrote in message news:f7p5st0rnvuquhc71ejbddbkor6p6n6oek_at_4ax.com...
> The server is an Oracle 8i server.
> 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 - 19:15:06 CEST