UNDO segment dump
Hi everyone ,
My transaction view shows me one transaction going on :-
SQL> select ubafil,ubablk,ubarec from v$transaction;
UBAFIL UBABLK UBAREC
---------- ---------- ----------
3 47460 5
And from dba_rollback_segs table i know the segment_name for corresponding block_id and file_id ..
SQL> select segment_name,file_id,block_id from dba_rollback_segs where tablespace_name ='UNDOTBS1';
SEGMENT_NAME FILE_ID BLOCK_ID
------------------------------ ---------- ----------
SYSSMU11192467665$ 3 9
SYSSMU21192467665$ 3 25
SYSSMU31192467665$ 3 41
SYSSMU41192467665$ 3 57
SYSSMU51192467665$ 3 73
SYSSMU61192467665$ 3 89
SYSSMU71192467665$ 3 105
SYSSMU81192467665$ 3 121
SYSSMU91192467665$ 3 137
SYSSMU101192467665$ 3 153
10 rows selected.
Now i want to dump the UNDO record entry which contains the transactionn details ..
How do i map it with the segment_name .. I mean segment_name contains block_id and v$transaction contains UBABlk address ..
And how can i dump it ?