"Chris" <cs123._no_spam__at_telstra.com> wrote in message
news:kVkJb.74915$aT.2175_at_news-server.bigpond.net.au...
>
> "computer person" <fake_address_at_nothing.com> wrote in message
> news:eJ5Jb.256601$ea%.219724_at_news01.bloor.is.net.cable.rogers.com...
> > Hi,
> >
> > We are migrating our systems from aix4.3.3 to solaris8. During migration
> we
> > noticed that the sqlplus queries take a lot longer with the Solaris
client
> > then with the aix sqlplus. This was proved by running the same query
> against
> > the solaris db server from a solaris client and aix and tabulating the
> > results.
> >
> > We found 1 thing that slowed it down and adjusted the SQL accordingly.
The
> > LINESIZE was set real high even though the result set was only 250 bytes
> max
> > (columns). This yielded very good results but we are looking for some
more
> > improvment, if possible.
> >
> > Any stories of people that use SQLPLUS on solaris and have gone through
> some
> > tuning with the client and got good results? Looks like our db server is
> > working well with exception of this.
> >
> > Thanks
> >
> >
> All thing being equal ie same network speed etc, then you may have a
> parameter like arraysize set wrong.
> Run autotrace on and have a look at your statistics when you try different
> arraysize.
> Asktom has a thread about this issue
>
http://asktom.oracle.com/pls/ask/f?p=4950:8:5020821875913409326::NO::F4950_P
> 8_DISPLAYID,F4950_P8_CRITERIA:880343948514,
>
>
9% decrease in execution time with arraysize 5000 or 1000.
Received on Wed Jan 07 2004 - 21:28:50 CST
