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

From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 18 Aug 1999 22:55:10 -0400
Message-ID: <pbKu3.1050$tp2.884@news.ipass.net>

Most common reason: waiting on disk I/O!

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Michael Keppler wrote in message <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 Wed Aug 18 1999 - 21:55:10 CDT