Re: Oracle 8 Tuning Question

Douglas,

its almost certain that your query is I/O bound rather than CPU bound. if you're on a unix platform checkout iostat to see if the disks are being worked hard

regards
brian

Douglas Peel wrote in message <7j0s72$ghr$1_at_nntp9.atl.mindspring.net>...
>Hey all,
>
>I am fairly new to the Oracle game and I'm having a tuning problem. I am
>running a query on a fairly large table (1M records) and it seems to be
>taking much longer than it should. I'm running Oracle 8 on and NT4.0
Server
>box. What I've noticed is when the query is being executed, the total CPU
>usage rarely (if ever) goes above around 16-18% and never above 25%, but,
>the query can take several minutes (3-10 minutes depending on result set)
to
>execute. Why would the CPU usage remain so low? Why not use all of the
CPU
>time? The box has no other tasks running simultaneously that should
prevent
>it from taking what it needs.
>
>I believe that I have all of the tables indexed properly and the query is
>optimized, but, like I said, I'm new enough to not be 100% sure.
>
>Any suggestions on this would be greatly appreciated.
>
>Doug
>
>dpeel_at_mindspring.com
>
>
Received on Fri Jun 04 1999 - 05:56:13 CDT