Re: Oracle tracing

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 19 Dec 2001 22:57:56 +0100
Message-ID: <i9322ucn9bjlcockfs0pr1ni0a48matkqk@4ax.com>

On Wed, 19 Dec 2001 16:53:45 +0200, "Sergei Gofman" <senq_at_innocent.com> wrote:

>Hi.
>I need a mechanism which allows me to get information about the excecuted
>queries in Oracle DB "on the fly" (in realtime). Alternatively, if you know
>a way to get trace of SQL queries with timestamps (when the query started
>execution) and the duration that the query took, that would also be good.
>The SQL_TRACE gives me only the queries, not the time when they started
>executing.
>Thanks in advance,
>Sergei
>

Check out v$sqlarea, The sql_address and sql_hash_value columns point to the actual query in v$sqltext_with_newlines.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Dec 19 2001 - 15:57:56 CST