ROWID和命令对应

select * from audit_actions; 查看命令号对应的具体命令

select dbms_rowid.rowid_object(rowid) obj,dbms_rowid.rowid_relative_fno(rowid) fno,dbms_rowid.rowid_block_number(rowid) bno,
dbms_rowid.rowid_row_number(rowid) rno from test.crmuser;  

rowID组成

1、row lock TX 数据

2、  table lock TM 原数据

a、 select    no lock

b、 row        exclusive lock

c、table

RS 2

RX 3

S   4

SRX 5

X      6