On 03/11/2004 08:05:27 PM, Tim Johnston wrote: > Hi Mladen... > > I was focusing on his original request... Or, my interpretation of > his problem... To me, the subject line is different then what he asked > for in the body of his email... He said he wanted to find out why a > particular user was encountering a problem at a particular point in the > application... With that in mind, I think a sql trace is an excellent > way of deterring what that user is doing and why he is waiting... > > The problem with using the v$sqlarea approach is he may identify 500 > statements that use more resources then the statement which is causing > him this issue... He could tune all of these statements and still not > solve the original problem since slow is a relative thing... > > However, if his original post was "What's the most resource intensive > SQL in my entire system", then a 10046 would not be the appropriate > solution... > Yes, you are right. I misunderstood the post. I'll get beaten for nothing. -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------