I'll get to oraperf eventually. I'm just cleaning out the cobwebs for now.
"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message
news:3df12ca9$0$11750$e4fe514c_at_news.xs4all.nl...
> My rule (learned from Oracle Technical Support) is: 10 minutes to
> investigate a problen (ofcourse when the problem is occuring), 30 min (or
> more) for a more global picture. The longer you run, the more the reffects
> are "averaged out".
> Do you know the site http://www.oraperf.com? You can upload the output of
> utlbstat/estat or statspack and get an analysis back.
>
> Brian E Dick <bdick_at_cox.net> schreef in berichtnieuws
> %v9I9.350$we.26721_at_news2.east.cox.net...
> | I'm going through the class materials for the Oracle University 8i
> | Performance and Tuning course I took a year ago. That's why I'm using
> | utlbstat/utlestat. How long should I run utlbstat/ultestat to get
> meaningful
> | stats? This system hardly has any load on it, so I'm taking the results
> with
> | a grain of salt anyways.
> |
> | "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> | news:kj72vugtgiehn28kdsmbe5kij0oesaghqf_at_4ax.com...
> | > On Fri, 06 Dec 2002 20:40:59 GMT, "Brian E Dick" <bdick_at_cox.net>
> | > wrote:
> | >
> | > >For all clients? That would explain it. I guess I need to dig into
the
> | > >utlbstat/utlestat code.
> | > >
> | > >"Brian E Dick" <bdick_at_cox.net> wrote in message
> | > >news:GT7I9.161$we.9094_at_news2.east.cox.net...
> | > >> The times for the wait events are in hundredths of seconds. I
waited
> | 334
> | > >> seconds between running utlbstat and utlestat. The SQL_Net message
> from
> | > >> client total time is 63684. That's 636.84 seconds, right? Am I
dense
> or
> | > >> what? How can the total wait time be greater than the run time?
> | > >>
> | > >> Later,
> | > >> BEDick
> | > >>
> | > >> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> | > >> PL/SQL Release 8.1.7.0.0 - Production
> | > >> CORE 8.1.7.0.0 Production
> | > >> TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
> | > >> NLSRTL Version 3.4.1.0.0 - Production
> | > >>
> | > >>
> | > >>
> | >
> | >
> | > I don't think so. Utlbstat/utlestat is not meant to run at such small
> | > intervals and the data you are getting is probably useless.
> | > Also in 8i you'd better use statspack.
> | >
> | >
> | > >
> | >
> | > Sybrand Bakker, Senior Oracle DBA
> | >
> | > To reply remove -verwijderdit from my e-mail address
> |
> |
> |
> |
>
Received on Fri Dec 06 2002 - 20:50:05 CST
