Re: Anyone running Oracle in OS/2

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