Re: Oracle 8 Tuning Question

Jet Long <jfllong_at_gte.net> wrote in message news:3785813A.CF0B5442_at_gte.net...
> If the queries are already optimized, the next thing that should be done
is to
> 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
> >
> > 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
> > >
> > >
>

hi
look up "explain plan", thats how i usually find out where trouble lies for a long query.
cheers
pr0d Received on Mon Jul 12 1999 - 07:50:35 CDT