Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F705B61.6C6FDFE0_at_remove_spam.peasland.com>...
> 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"
thanks... got it now.
Received on Tue Sep 23 2003 - 13:23:43 CDT
