Re: Question on Rollback Transaction Query

Then it works! Thank you for your hint.

Martin Haltmayer

Quinton McCombs wrote:
>
> 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 Thu Feb 26 1998 - 00:00:00 CET