Re: Question on Rollback Transaction Query

On Wed, 25 Feb 1998 06:30:56 +0100, Martin Haltmayer <Martin_Haltmayer_at_KirchGruppe.de> wrote: Hi,

the eistence and availibilty of the 'x'-tables may change from one oracle version to the other. that's what german support said to me the teime I had a similar prob.

>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

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de