Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Wait Statistics and tuning an individual query
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