Re: Question on Rollback Transaction Query

From: Steve Adams <steveadams_at_acslink.net.au>
Date: 1998/02/24
Message-ID: <34f241ff.1658096576_at_newsserver.trl.oz.au>#1/1

[Quoted] Hi Simon,

Is this what you are after?

select
  kxidusn || '.' || kxidslt || '.' || kxidsqn xid,   decode(bitand(ktcxbflg, 128), 0, 'Active', 'Rollback in Progress') status
from
  x$ktcxb
where
  ktcxbsta = 10
/

Regards,
Steve Adams
steveadams_at_aclink.net.au

---

On 19 Feb 1998 21:02:56 GMT, "Simon" <s_adams_at_hotmail.com> wrote:

>Is it possible to query the state of transactions in the rollback and their
>status etc?
>
>Simon
Received on Tue Feb 24 1998 - 00:00:00 CET