Re: Oracle 8 Tuning Question

[Quoted] If the queries are already optimized, the next thing that should be done is to [Quoted] run "utlbstat" and "utlestat". These scipts will let you know what your bottlenecks are.

Brian Gallagher wrote:

> 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
> [Quoted]
> 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 Jul 09 1999 - 06:53:10 CEST