Re: how to find the most resource intensive sql?

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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------