Re: Oracle 8 Tuning Question

From: XU <xux_at_informa.bio.caltech.edu>
Date: 1 Jun 1999 16:03:13 GMT
Message-ID: <7j1081$j0f@gap.cco.caltech.edu>

1 million records is not large at all. If your query is not very complicated, it should not take minutes to execute. There are too many things that could affect tuning and speed. Maybe you should look into SGA, query hints, etc. In additon, indexes may NOT always speed up things.

Robert XU

Douglas Peel (dpeel_at_mindspring.com) wrote:
: 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 Tue Jun 01 1999 - 11:03:13 CDT