dump 特定的buffer block
alter session set events ‘immediate trace name set_tsn_p1 level ts#’;
alter session set events ‘immediate trace name buffers level level#’;
其中,
ts#=relative_file#+1
relative_file# in(select dbms_rowid.rowid_relative_fno(rowid) relative_file#,dbms_rowid.rowid_object(rowid) obj#,dbms_rowid.rowid_block_number(rowid) block#,id from wangxin.t);
level#=select dbms_utility.make_data_block_address(relative_file#,block#) from dual;
block# in (select dbms_rowid.rowid_relative_fno(rowid) relative_file#,dbms_rowid.rowid_object(rowid) obj#,dbms_rowid.rowid_block_number(rowid) block#,id from wangxin.t);
alter session set events ‘immediate trace name set_tsn_p1 level 13’;
alter session set events ‘immediate trace name buffers level 50331782’;
select value from v$diag_info where name like ‘De%’;