Re: Wait Statistics and tuning an individual query

You'll have to read the raw trace files. Level 12 will give you wait events and bind variable information. The info is in the raw trace files. TKPROF strips this information out. If you need information on reading raw trace files, email me directly.

HTH,
Brian

Ryan 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?
>
> 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"

-- 
===================================================================

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"