How to increase speed

[itbnorris]

Our database server is consistantly using 70-100% of our processor time. Would anyone mind throwing out some ideas of how we might improve this? My specialty isn't Oracle, so forgive me if I make no sense. Our DBA is on medical leave, so I'm left with coming up with possible solutions to improve our performance (I'm normally a programmer!).

Our current DB server is Windows 2003 Enterprise, w/ dual 1.4 GHz Processors, 4 GB DDR memory, 8 73 GB disks (RAID 5). We support about 200 users, on 6i Forms and Oracle9i AS Portal. The database consists of financials, resource tracking, job tracking, and similar, and is now about 80 GB in size. We're using about 2 GB of memory at any given time.

I've read about Real Application Clusters, but does this provide a performance gain? We have another box that is underutilized w/ dual 2.8 GHz processors if clustering would help.

As is, we're considering buying a quad processor server.

I'm sure some of our problem has to do with some of the reports/queries we allow/run. However, management doesn't want to change the capability our applications give, and we've tuned as much as we can.

Anyone have any other ideas how we might improve our performance?

 

[SantaMufasa]

...we've tuned as much as we can

Tell us what tuning you have done.

We support about 200 users

Are those concurrent users?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.