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: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 24 Sep 2003 06:52:41 -0700
Message-ID: <1efdad5b.0309240552.3bd0a13f@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 - 08:52:41 CDT

Original text of this message

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