RE: how to find the most resource intensive sql?

From: Lim, Binley <Binley.Lim_at_NBNZ.CO.NZ>
Date: Fri, 12 Mar 2004 11:19:23 +1300
Message-ID: <5FA85DB5FB07D7118CF50002A5754C0902E2CA24@nbnzhexch2.nbnz.co.nz>

> 'A user comes to you and says they get to a point in the application and
hit
> a button. It's slow. You do not have any access to the application. How do
> you find the problem query in the database'

In a (preferably) test system, ask the user to get to the point just before the "button".

Flush the shared_pool, then push the button.

This communication is confidential and may contain privileged material. If you are not the intended recipient you must not use, disclose, copy or retain it. If you have received it in error please immediately notify me by return email and delete the emails.
Thank you.

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
-----------------------------------------------------------------

Received on Thu Mar 11 2004 - 17:15:45 CST