Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Wait Statistics and tuning an individual query
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?
Is that incorrect. Its hard to dig up documentation on sql trace.
"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
news:3F6F49CD.E0C48168_at_remove_spam.peasland.com...
> You don't have to do Statspack, and you don't even need 9i. You can
> start a 10046 trace (level 8) to get a SQL trace of your session's
> statements along with wait events.
>
> HTH,
> Brian
>
> Ryan Gaffuri wrote:
> >
> > I noticed that in 9i you can get the wait events in the sqltrace. Im
> > on 8.1.7.3
> > at work. Is the only way to get the wait events to either run
> > statspack before and after the query, then print out a report or to do
> > it myself with scripts or is there another way to get it?
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Mon Sep 22 2003 - 22:25:26 CDT