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
http://www.petefinnigan.com/ramblings/how_to_set_trace.htm. 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!
http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&source=hmtagline
--
//www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
