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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 14 Jul 2003 20:21:55 +0200
Message-ID: <a3t5hv4lgupnr04k2tf439cekgcu50docj@4ax.com>

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.

Designing and tuning for performance chapter 6

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992/ch14_str.htm

Please do some research before posting. The only thing I did was typing "sql trace" in the search engine of tahiti.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jul 14 2003 - 13:21:55 CDT