"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,
Received on Fri Jan 02 2004 - 14:55:44 CST
