Re: Rollback Segmente

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 31 May 2002 19:34:24 GMT
Message-ID: <4fQJ8.30898$wj7.11599257@twister.socal.rr.com>

select sid, v$rollname.name
from v$session, v$transaction, v$rollname where v$session.taddr = v$transaction.addr (+)   and v$transaction.xidusn = v$rollname.usn (+)   and sid = (
    select sid
    from v$mystat
    where rownum = 1)

Of course, you have to actually have an active transaction for this to work.

Richard

Uwe Schmidt wrote:
>
> Hi Newsgroup,
>
> if I'm connected to Oracle by sqlplus; how can I see in which rollback
> segment I'm working?
>
> So long
> Uwe
Received on Fri May 31 2002 - 14:34:24 CDT