Re: Can I find out what SQL a trascation try to exec ?

On Wed, 19 Jan 2000 19:01:43 +0800, "Ken Gibson" <kengibz_at_singnet.com.sg> wrote:

>Hi,
> Base a trascantion id, can I find the SQL that the transaction try to
>exec ? Can I find it in V$SQL ?
>
>
>--
>Best Regard
>
>Ken
>
>

You need to join v$session and v$sqltext_with_newline. The join columns are the sql_addr(ess) and the hash_value. I always use the sid and the serial# to locate the session, sid and serial are without doubt in v$lock and the like.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Jan 19 2000 - 08:09:51 CST