RE: undo block number
Date: Wed, 11 Mar 2015 07:47:18 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA63701E0DC_at_HKWPIPXMB03C.zone1.scb.net>
That wouldn’t identify all the undo blocks for the transaction, would it ? Because a transaction can be using many Undo Blocks. But the transaction has only 1 entry in v$transaction. So not all the Undo blocks would be visible. Unless one knew how to walk the chain of undo blocks, beginning with dumping the first undo block, reading the trace, finding the next undo block for the transaction, then dumping it and so on.
Hemant K Chitale
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan
Sent: Tuesday, March 10, 2015 9:39 PM
To: cure_at_austin.rr.com
Cc: Oracle Mailinglist
Subject: Re: undo block number
Paul--
Look for UBA-BLK/FIL/REC values in the V$transaction and dump those blocks for the transaction id.. XID is USN.SLOT#.WRAP#.
-Gopal
On Tue, Mar 10, 2015 at 8:21 AM, Paul Harrison <cure_at_austin.rr.com<mailto:cure_at_austin.rr.com>> wrote: Hi All,
How does one find the undo block number associated with a transaction? I want to dump the undo block to see the contents?
Below is the block number associated with the data block but not sure how to find the undo block number for this transaction. Is the “Uba” of the Transaction table the undo block number?
select
2 dbms_rowid.rowid_relative_fno(rowid) File#,
dbms_rowid.rowid_block_number(rowid) Block#
4 from t1
5 ;
FILE# BLOCK#
---------- ----------
1 93569
1 93569
1 93569
1 93569
Thanks,
Paul
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 11 2015 - 08:47:18 CET