Re: Performance improvement problem

It would be unusual to need to have swap greated than twice memory unless you system is undersized. If you feel you have a performance problem use the Oracle Tuning Guide to identify the area and address it directly.

Regards
David Russell

Terence T wrote in message <01bda0e5$bbb22090$76070006_at_pgntw90>...
>Good day
>I am running Oracle 7.3.3 on Sun Solaris 2.5.1
>Not long ago I recieved advice from someone that to increase my database
>performance, I should:
>1. Make the swap space at least 3 times the RAM
>2. Make the ulimit as unlimited
>3. Set the datasize and stack size unlimited.
>I believe that Step 1 involves repartiotioning the server, pls confirm if I
>am right.
>However I am not sure about how to go about doing step 2 and 3, apprecieate
>any help.
>Also... has anyone know or have actual experience of whether those steps
>would increase the database performance and to what extent?
>I am running Oracle 7.3.3 on Sun Solaris 2.5.1
>Pls reply to wk.teoh_at_amd.com
Received on Sat Jun 27 1998 - 18:01:16 CDT