dump block changes 11gR2
- From: "April Sims" <sims@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Mar 2010 07:10:16 -0700
Anyone looking at dump block in 11.2.0.1 yet?
Looks like different behavior than in 11.1.0.7.
Appreciate any insight or other information. Perhaps a different query
than using dbms_rowid?
Dumping blocks by using the following query seems to be getting headers
for certain DML.
Tried dumping as sys and as schema owner, same results.
select dbms_rowid.rowid_relative_fno(rowid) as filenumber,
dbms_rowid.rowid_block_number(rowid) as blocknumber from tablename;
Here is the order and dumping block for each step.
INSERT - header
COMMIT - header
UPDATE - header
COMMIT - header
DELETE - data
COMMIT - data
The undo blocks dump are different in 11gR2 as well.
thanks
April Sims
SELECT IOUG Contributing Editor
http://aprilcsims.wordpress.com
http://www.twitter.com/aprilcsims
Oracle Database 11g – Underground Advice for Database Administrators
OCP 8i, 9i, 10g DBA
Southern Utah University
sims@xxxxxxx
940-484-4276
Other related posts:
- » dump block changes 11gR2 - April Sims
