Re: Wait Statistics and tuning an individual query

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"