Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Wait Statistics and tuning an individual query
Ryan
Take a look at the SQL scripts and you will see that it was originally an apps tool and is indeed relatively new. I suspect the reason it isn't widely known is exactly because it appears to come from the apps team rather than the dbms team.
-- Niall Litchfield Oracle DBA Audit Commission UK "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0309240552.3bd0a13f_at_posting.google.com...Received on Wed Sep 24 2003 - 09:48:27 CDT
> Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message
news:<4nu0nvci11ctgrbjo0jb1fn4t8idup12he_at_4ax.com>...
> > On Mon, 22 Sep 2003 23:25:26 -0400, "Ryan" <rgaffuri_at_cox.net> wrote:
> >
> > >I did level 12 context forever and I dont recall getting wait events
when I
> > >did a tkprof. Do I have to use a specific tkprof setting?
> >
> >
> > They are in the raw trace files. You can download a package called
> > trc_anlzr from Metalink to have them formatted for you. You will be
> > stunned by the results
> >
> >
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> trace analyzer is terrific. Much more detail than tkprof. How did you
> hear about it? Its not even in Tom Kytes new book. must be new.
![]() |
![]() |