Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: New Oracle New Solaris v's Old Oracle Old Windows

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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 14 Apr 2004 07:35:36 -0700
Message-ID: <1081953325.353763@yasure>


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)
Received on Wed Apr 14 2004 - 09:35:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US