Re: New Oracle New Solaris v's Old Oracle Old Windows

Tim Smith wrote:
> 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
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)