Re: tracing the sql that an Oracle process is executing?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 14 Jul 2003 18:25:08 GMT
Message-ID: <3f12f580.602966359@nyc.news.speakeasy.net>

http://www.adm.cbs.dk/aida/aijhn/bindtrc.html On 14 Jul 2003 17:56:45 GMT, Holger Marzen <holger_at_marzen.de> wrote:

>Oracle 8.1.7 on Solaris 7:
>
>We run an application with many local Oracle connections. 2 long living
>Oracle processes using lots of CPU. The application developers ask for
>help, if I could trace "something".
>
>With db2 there is a trace facility that can attach to a running db and
>write the sql commands that are executed. So I could help a db2
>deveoloper showing him that his application did the same sql again and
>again.
>
>Is there a similar way to attach to a special Oracle process and show
>the sql that this process is executing? That would help them a lot.

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Mon Jul 14 2003 - 13:25:08 CDT