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
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