Re: Extracting query from application

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Tue, 24 Oct 2006 16:59:59 +0100

If you are using a dedicated connection the easiest way to do this is to
enable sql_trace for that session. You *will* find an appropriate method at shared
connections present more of a challenge.

On 10/24/06, J. Dex <cemail_219@xxxxxxxxxxx> wrote:

We are having a problem with an application and the application does not have a tool to easily identify what query is being sent. From a sqlplus side, is there a way to extract the query the application is sending and also list how long it took and when the data is transferred back?

Try the next generation of search with Windows Live Search today!


Niall Litchfield
Oracle DBA

Other related posts: