Have you ANALYZEed your tables ??
Reiner
Douglas Peel <dpeel_at_mindspring.com> schrieb in im Newsbeitrag:
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 Wed Jun 02 1999 - 06:14:50 CDT
