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: Why doesn't Oracle run at 100 percent processor time on queries??

Re: Why doesn't Oracle run at 100 percent processor time on queries??

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Thu, 19 Aug 1999 20:35:38 -0700
Message-ID: <F14v3.2735$FG4.103893@news1.teleport.com>


Disk I/O. One of the sites I work with was having performance problems. The 4 processor NT server had plenty of RAM and the CPU's were averaging 10 to 15% with peaks of 35-40%. Once we looked at the disk queue length and saw averages of 5 and peaks of 15! We figured it was an I/O problem.

We found they had turned on virus checking on all files on all directories on the box. So we turned it off and got an immediate 50% performance improvement. (the virus scan software was scanning the Oracle files everytime they changed....not good for I/O problems)

Then we got them to buy more drives and had them put redo on another one (all of this is standard stuff) and viola! performance was much better and the CPU usage went up!
Jim
Michael Keppler <Michael.Keppler_at_bigfoot.com> wrote in message news:7pehe4$7st_at_TGZ3...
> Hello everybody !
>
> We have a dedicated Oracle 8 Server running on NT. Sometimes we run many
> queries in one transaction or use queries that need some seconds to
> process. And I never see the percent processor time higher than maybe 30
> or 40 percent. And its not because of disk performance, the raid set is
> only sometimes reading or writing.
>
> How can I get Oracle using all the available processor time?
> That would make my queries as double fast as now and at the moment there
> is only one client making connections to the database.
>
> Thanks and Good Bye, Michael.
>
> --
> Michael.Keppler_at_bigfoot.com
>
>
Received on Thu Aug 19 1999 - 22:35:38 CDT

Original text of this message

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