Re: V$session_wait question and rollback segments

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 4 May 2004 21:08:02 +0100
Message-ID: <001801c43214$1b41d350$7102a8c0@Primary>

You've lost a bit of your wait.
>From your previous post:

name|mode

0000000054580006
id1

0000000000030035
id2

000000000007D963

Name/Mode:

5458 / 06
T X / mode 6 (exclusive)

ID1

3 35 Undo segment 3, slot 0x35 ID2

7D963 Sequence number

The ID1 / ID2 correspond to the id1/id2 in v$lock which also correspond, after slicing up into the

    XIDUSN
    XIDSLOT
    XIDSQN
from v$transaction.

This is one of the ones that is easier to read in Hex than it is in the decimal form.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Optimising Oracle Seminar
http://www.jlcomp.demon.co.uk/seminar.html

June 2004 UK Manchester
July 2004 Iceland
July 2004 USA California
Aug 2004 USA North Carolina
Sept 2004 UK Manchester
Sept 2004 USA NYC
Oct 2004 USA Boston

Original Message ----- From: "Diego Cutrone" <diegocutrone_at_yahoo.com.ar> To: "Oracle List" <oracle-l_at_freelists.org> Sent: Tuesday, May 04, 2004 4:25 AM Subject: V$session_wait question and rollback segments

Hi List,
Does anybody know how to derivate the rollback number and the slot number within the rollback transaction table from v$session_wait id1 and id2 on an enqueue TX wait?

      SID                   ID1                         ID2
      112     enqueue  0000000054580006 0000000000030035

I know there's a formula for this, but I just can't find it.

Thank you
I really appreciate your help.
Regards
Diego.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 04 2004 - 15:09:58 CDT