mysql相关文档

2.9.8

create table itpux1(id number,name varchar2(20));
insert into itpux1 values(1,'a');
insert into itpux1 values(2,'b');
select * from itpux1;

select dbms_rowid.rowid_relative_fno(rowid) file_number,dbms_rowid.rowid_block_number(rowid) block_number from itpux1;

--1  2425
--1  2425

select * from dba_objects where object_name='ITPUX02';

--data_object_id 91645

alter system flush buffer_cache

select * from v$bh where objd=91645

update itpux02 set name='c' where id='1';

select * from v$transaction

select xidusn,xidslot,xidsqn,ubafil,ubablk from v$transaction

--查看回滚段的名字
select * from v$rollname where usn=7;