Re: Optimization question

In article <Cv1938.2I4_at_ncbol.msk.su> alex_at_ncbol.msk.su (Alex Stebletsov) writes:
>Pete Kuba (pkuba_at_cnj.digex.net) wrote:
>: The company that I'm working for has Oracle 7.0.13 running on SCO Unix on
>: a 486/66 w/ 32Mb. If there are more than a few users logged on,
>: performance starts to really lag. Since I'm a programmer and not a dba
>: (and since the company doesn't want to pay a dba), I'm wondering how to
>: answer my boss' question, "what do we need make things fast?"
>
>Add more memory and expand SGA. Try to set tunable parameters
>in init.ora file to 'large' model.
>
>My screwings with Oracle 6 on SCO ODT 3 showed up that moving onto raw
>partitions doesn't add alot of performance.
>
>If feeding simms doesn't help, your next step could be upgrade to Pentium.
>

You may not want to increase the size of the SGA right away. If your performance degrades with multiple users, it may be that the extra users are putting your memory requirements "over the edge" (over real memory) and are causing your system to SWAP, and if the Oracle SGA gets swapped to disk, performance will be abysmal. Check out VMSTAT and see if you are paging to disk. If so, then REDUCE the size of your SGA if you need to have additional users. Of course the best thing is to get more memory, and a pentium and on and on and on.....

If you are not swapping, then you will want to tune your init.ora parameters.

-David

-- 


---------------------------
David Pinkus
Database Systems Consultant
dpinkus_at_netcom.com

h 415.922.8111
w 415.396.1252
f 415.362.1052