Re: Wait Statistics and tuning an individual query

From: Stan <stan0074_at_remove_this.comcast.net>
Date: Tue, 23 Sep 2003 05:29:04 GMT
Message-ID: <3F6FDA20.9030600@remove_this.comcast.net>

Ryan,

tkprof (prior to 9i) won't format or basically ignores wait events in trace files but 9i does. if you are back after a nicer format for wait events, then use 9i tkprof to format 8.1.x trace files, that should help.

Stan

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"

> 
> 
> 

-- 
-Stan

To reply remove the obvious ones from my email address

Received on Tue Sep 23 2003 - 00:29:04 CDT