Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Peeking into another transaction
Very useful, indeed! This seems to solve my problem.
Thanks a lot for answering my question.
MK
> >Hello
> >
> >I am wondering if it is possible to peek into another
> >transaction/session.
> >That is, if I can make oracle let me see what another transaction is
> >actually seeing, thus foregoing the service that rollback (consistent
> >gets?) provides.
> >
> >I am asking this because I have a procedure which is running since a
> >long
> >time ago and I'd like to see how far it has already progressed. I am
> >aware that I can query used_urec in v$transaction, but I have no idea
> >which amount used_urec will have when the procedure in question is
> >finished. The version is 8i, but I am also interested if there is
> >something like this on 9i.
> >
> >thanks
> >MK
>
> Please refer to v$session_longops.
> It contains the info you require
>
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri May 17 2002 - 03:03:23 CDT