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: Sergey Khochay <ksergey_at_pacbell.net>
Date: Wed, 18 Aug 1999 22:24:16 -0700
Message-ID: <2yMu3.791$26.140630@typhoon-sf.snfc21.pbi.net>


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

Original text of this message

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