Re: Help:Pending transactions

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 17 Nov 1998 20:35:41 GMT
Message-ID: <01be1269$2091ba80$0300a8c0@WORKSTATION>

Mark Powell <Mark.Powell_at_eds.com> wrote in article <01be1232$c91342a0$a12c6394_at_J00679271.ddc.eds.com>...
>
> select the sid from using the userenv function
> join this sid to the audit sid, audsid, in the v$session to get the
> v$session sid
> using the v$session sid retrieve all matching rows in v$lock if
any,
> no rows would mean no locks
> You might need to limit your lock search by type and mode depending
on what
> it is you want to allow and disallow to be pending.

An alternative is to check your own v$session row to see if the TADDR column is null or not. Received on Tue Nov 17 1998 - 14:35:41 CST