Re: Question on Rollback Transaction Query

[Quoted] You must be connected as sys to access x$ tables.

Martin Haltmayer wrote:
>
> 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