Re: Anyone running Oracle in OS/2

Another yes for Oracle7 on OS/2. I have not done any performance tuning either, but I believe the standard tuning tips apply. See below.

-Brian

Simon Thompson (scthomp_at_ibm.net) wrote:
: In message <DIvCKA.MEJ_at_freenet.carleton.ca> - ai178_at_FreeNet.Carleton.CA (Ian Ab
: ramson) writes:
 

: :> I would like to know if anyone is currently running Oracle 7 in
: :>an OS/2 environment.
 

: Yep.
 

: :>
: :> I would like to get some hints on areas that we can look at to
: :>improve performance. This system has a lot of data that is relatively
: :>stable. Data is normally loaded via SQL*loader...
 

: I have yet to do any real performance tuning - it hasn't been a problem, so
: isn't a priority. I am getting SPM/2 (via AttachPak for Warp Connect) soon so
: I can analyse the machines performance to find any (potential?) bottlenecks.
 

: Some ideas:
 

: Are you caching the smaller tables (Oracle 7.1 feature).
 

: Have you tried changing the block size? I plan to try 8Kb (vs 2Kb). This is
: supposed to improve read performance, but may impar writes. For static
: data, that is ok.
 

: Do you use any RAID? I have most of my data on RAID 5 as it has the better
: read performance. Again, that suits static data. I have my temprary data
: table on a single disk. No crucial data goes onto that disk; only temporary
: data.
 

: Have you tried moving some tablespaces, log files, control files, etc. to
: different (physical) drives. Spreading your files can help performance.
 

: Cheers.
 

: +---------------------------
: | Simon Thompson
: | Christchurch
: | New Zealand

--
------------
SHENSKYbrian    313.454.9603 (home)     shensky_at_umich.edu (email)
                313.780.3213 (page)     http://www.umich.edu/~shensky (www)