| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Upgrade Suggestions????
"Rule-z" <rulet_at_rpi.edu> wrote:
>Currently using a Sparc Sun 4M 48 mb Ram (os 5.5) Unix with oracle 7.2.3.
>Roughly about 20-25 users. Really bogs on queries and reports. Any
>suggestions would be helpfull, Stay with Unix or go to NT and what about the
>hardware? Thanks in advance?
48 MB of RAM is pretty slim, considering 32 MB is a practical minimum for the OS, and 20-25 users eats another 25 MB or so, plus you've got your SGA, etc.
First, buy some RAM - it's cheap. Upgrade to at least 128.
Second, examine your queries - they may be inefficient. The bulk of your improvement will come from ensuring that your queries are efficiently written and that your tables are properly indexed.
Chris
 |
 |