Re: MVS and large database
Date: 1996/07/15
Message-ID: <summersd.160.0013DCF5_at_teleport.com>#1/1
In article <iN9swBAoSm5xEwRI_at_mitc.demon.co.uk> Brian McCabe <brian_at_mitc.demon.co.uk> writes:
>Path:
>nntp.teleport.com!netaxs.com!hunter.premier.net!news-res.gsl.net!news.gsl.net!ne
>ws.mathworks.com!news.kei.com!nntp.coast.net!dispatch.news.demon.net!demon!mitc.
>demon.co.uk!brian
>From: Brian McCabe <brian_at_mitc.demon.co.uk>
>Newsgroups: comp.databases.oracle
>Subject: Re: MVS and large database
>Date: Fri, 12 Jul 1996 15:43:52 +0100
>Organization: McCabe IT Consulting Limited
>Lines: 67
>Distribution: world
>Message-ID: <iN9swBAoSm5xEwRI_at_mitc.demon.co.uk>
>References: <4r6d08$39d_at_news00.btx.dtag.de> <1996Jul8.220146.7060_at_rossinc.com>
> <4ruqv3$h4_at_inet-nntp-gw-1.us.oracle.com> <Q1VakDAII14xEwtp_at_mitc.demon.co.uk>
> <31E676C4.55D1_at_nla.gov.au>
>NNTP-Posting-Host: mitc.demon.co.uk
>X-NNTP-Posting-Host: mitc.demon.co.uk
>MIME-Version: 1.0
>X-Newsreader: Turnpike Version 1.12 <JuRssnRnjILJ3N01Yp$Sfk242+>
>In article <31E676C4.55D1_at_nla.gov.au>, Bruce Pihlamae
><bpihlama_at_nla.gov.au> writes
>>Brian McCabe wrote:
>>> The site I am working at is also experiencing problems with Oracle
>>> performance on MVS. We are planning to migrate from AIX to MVS and
>>> although the database only currently stands at less than 100Gb, we
>>> intend to reach pretty near to the 1Tb figure next year.
>>>
>>> Initial performance of Oracle on MVS is very disappointing and no
>>> obvious bottle-neck has been determined to date. The Orace Instance is
>>> idling, the network is not under any great stress and the MVS-Gurus tell
>>> us that nothing is pushing the operating system or disk IO sub-system.
>>>
Is it possible that you are being limited by the speedof your SQL*net
connection? I use the DB2 transparent gateway( which uses an oracle7 instance)
on MVS connected to an Oracle7 Instance on a Solaris bax via SQLNet2. Without
a doubt the slowest piece is the SQLnet. We've monitored it with a sniffer and
discovered that data transfet involves many small messages bracketting a
maximum 2k packet. We haven't found any way (yet) to improve on this.
Received on Mon Jul 15 1996 - 00:00:00 CEST