utlbstate/utlestat

Bulent, I am not able to reply your email because of some domain problem. So I have posted the reply in this newsgroup.

You will need to do the following:

1. Detemine the period that is causing the performance issue
2. Run the script utlbstat.sql using svrmgrl at the begining of that period. (The script should be located in $ORACLE_HOME/rdbms/admin)
3. Run the script utlestat.sql at the end of the period. A file called report.txt should be generated.

Report.txt has a list of statistics about memory usage and I/O distribution. By looking at these statistics, you will have an idea ofwhat are going wrong.

Hope this help.

I read your response to a posting in Oracle.database list. I have similar problems, and I'm trying to find ways to increase speed. How can I use "utlbstat" and "utlestat", and what do they tell me?

Thanks you.

Bulent Gumus
Software Engineer
OnBoard Software, Inc.
Kelly AFB, Texas 78241

Ph: (210) 932 1683 Ext. 3392
Fax: (210) 925 2144
http://members.xoom.com/bgumus/
http://www.onboard-software.com

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
Received on Mon Jul 12 1999 - 23:58:16 CDT