Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why doesn't Oracle run at 100 percent processor time on queries??
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