Re: Question on Rollback Transaction Query

[Quoted] [Quoted] I got the following error with Oracle 7.3.3.5:

  x$ktcxb
  *
ERROR at line 6:
ORA-00942: table or view does not exist

Martin Haltmayer

Steve Adams wrote:
>
> 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 Wed Feb 25 1998 - 00:00:00 CET