I guess ID1 =3D 65536 * USN + slot number -----Original Message----- From: Diego Cutrone [mailto:diegocutrone@xxxxxxxxxxxx] Sent: Monday, May 03, 2004 11:26 PM To: Oracle List 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------