Re: Performance Advice Wanted

In article <4aoo52$1jj0_at_news-s01.ny.us.ibm.net>, scthomp_at_ibm.net (Simon Thompson) says:
>
>I have Oracle7.1 running under OS/2. Up until now, it has also been my
>workstation. I now have another PC (also running OS/2) as my desktop PC. The
>machine with Oracle on it is now a dedicated server.
>
>Every night, files are loaded into Oracle using SQL*Loader. They are then
>processed. Some summary tables are built.
>
>At present, the process is run totally on the Server. I am trying to work out
>if it would be better to run the process from the desktop PC.
>
>The advantages of running it on the server is that there is no network
>(SQL*Net 2.1 over TCP/IP) to slow it down. The disadvantage is that the
>process is using memory and some processing power.
>
>The server is a Pentium 66Mhz, 64Mb RAM, with RAID-5 on SCSI II. The desktop
>is a Pentium 133Mhz, 32Mb of RAM (it is newer).
>
>Does anyone have any advice or comments?
>
>TIA.
>
>+---------------------------
>| Simon Thompson
>| Christchurch
>| New Zealand
>

Hi Simon,

this might very well be an open door, but I'm going to push my luck anyway.

I doubt if running processes from the desktop would do you any good even though it's a pretty 'mean-machine'. In general increasing the SGA size by adjusting/increasing some parameters can do a world of good. If you've tried that already, sorry ! I'm not much help. If not, try increasing the parameters

DB_BLOCK_BUFFERS
SHARED_POOL in your init'dbname',ora file to a number larger as what oracle itself indicates as 'large'. On a 64Mb machine an SGA size of 20 to 25 Mb must a possible option (unless Oracle is only a minor part of the work ofcourse).

Good luck.

Gerrit Received on Mon Dec 18 1995 - 00:00:00 CET