Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Wait Statistics and tuning an individual query

Re: Wait Statistics and tuning an individual query

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 24 Sep 2003 15:48:27 +0100
Message-ID: <3f71aebc$0$250$ed9e5944@reading.news.pipex.net>


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...

> 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.
Received on Wed Sep 24 2003 - 09:48:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US