Oracle 8.1.6.0.0 performance boost options

Hi,

We have a current production db installation running Oracle 8.1.6.0.0 running on an HP Netserver LH3 with 512 MBytes RAM and 3 drives for the Oracle Db mirrored.

We have performance problems, with queries that are not using indexes, sometimes because they access views, and indexes are not used (tempdb). The temp db access appears to overload the cpu.

1. We may not have time to fix the bad sql. Is installation of a RAM disk for tempdb a viable alternative to speed up the temp db access, and also reduce load to the CPU?
2. The hardware is 3 years old. With the newer smart scsi, how much speed improvement can be had, simply by upgrading hardware? Any interesting comments?
3. What about Linux vs NT? I know Oracle won't publish TPC benchmarks by OS. However, there must be some way to figure out which is better, and by how much.

thx

Mark Received on Wed May 23 2001 - 18:42:01 CDT