mccmx_at_hotmail.com wrote:
>> Did you ever end up running it through orarsp? I wrote a trace parser
>> a while back that printed statements in execution order, and the
>> elapsed time between each. It has proven to be very useful to me for
>> this kind of thing, but wouldn't be of use to you in this specific
>> case. I would be curious to see what you get from something like
>> orarsp. I can say that I have always seen aberrations in the timings,
>> but never anything as large as the disparity you are seeing.
>>
>
> Yeah just ran it through yesterday. I found that orasrp was much
> better at pinpointing the root of a performance problem than tkprof.
This may be true but the ORASRP project has been closed. It appears
to be a technological dead-end.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Oct 13 2006 - 12:06:01 CDT
