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??
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 Thu Aug 19 1999 - 00:24:16 CDT