Very Computer

by **Tim Smi** » Thu, 15 Apr 2004 11:38:20

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

by **Daniel Morga** » Thu, 15 Apr 2004 23:35:36

> 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

To solve your problem ... fix the problem. No hardware, operating
system or Oracle version/edition will do that.

My recommendation would be Solaris 2.8 w/ Oracle 9.2.0.4 if the
intent is immediate production usage.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

(replace 'x' with a 'u' to reply)

Very Computer

New Oracle New Solaris v's Old Oracle Old Windows

New Oracle New Solaris v's Old Oracle Old Windows

New Oracle New Solaris v's Old Oracle Old Windows