New Oracle New Solaris v's Old Oracle Old Windows

I am receiving new Sun Fire 440 with 2 processors and I believe 10-12 disks (waiting for info on disks). I could ask for Solaris 8 or 9. I could install Oracle 8,9 or 10 (I suppose).

Our production software runs on a Windows 2000 Server cluster with Oracle 8.0.5. A mix of Powerbuilder clients (10-15 users) and ASP.NET clients (20-80 users). The dual nodes are both Pentium IV processors with 2GB RAM each.

Most of the performance issues of our application is from inefficient SQLs with large numbers of logical reads. Disk I/O is rarely an issue though perhaps there will eventually be some redo log contention.

So we developed a multithreaded application which emulates browsers and users and can execute the workflow processes to put the system under serious strain. With 40-60 users performance becomes unacceptable.

Now I have new Solaris Hardware and my choice of the latest Oracle database. Which version(s) shall I install and configure - for my logical read bottleneck is there any type of configuration for this OLTP application that I can use with the latest software to create some impressive improvements?

I can do the technical research but if you have some great ideas please share!

thanks!

Tim Received on Tue Apr 13 2004 - 21:38:20 CDT