Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news2.euro.net!newsgate.cistron.nl!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!freenix!sn-xit-02!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: bad performance with sqlplus on solaris Date: Thu, 01 Jan 2004 21:31:30 -0800 Organization: ATS Message-ID: <1073021402.541797@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 41 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:251130 computer person wrote: > 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 Based on what you've written my guess is that you are ignoring the obvious and trying to fix the trivial. What got migrated from AIX to Solaris? Server or Client or both? What is the hardware difference? RAM? CPU? DASD? What differences in init parameters? Which version and edition of Oracle? Which optimizer? If CBO were statistics run with DBMS_STATS after migration? Unless you are being billed by the byte a bit of information would be helpful. Cryptic information begats cryptic responses. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)