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

It depends on the platform you are working at. I.e. if you are using Alpha proccessor everything runs 100%. On the other hand Intel proccessors almost never run at 100% :( .

Sergey Khochay wrote:

> Which prosess is running 100%??????????
>
> 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 Fri Aug 20 1999 - 04:21:56 CDT