Re: V$session_wait question and rollback segments
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 May 2004 21:08:02 +0100
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@xxxxxxxxxxxx>
To: "Oracle List" <oracle-l@xxxxxxxxxxxxx>
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@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
-----------------------------------------------------------------
Other related posts:
