Oracle数据库中的数据块存储 -- data block storage in an Oracle Database
来源:锐游网
A. A block header contains a row directory pointing to all rows in the block.
B. Row data is stored starting at the end of the block.
C. An index block can contain row data
select DBMS_ROWID.ROWID_OBJECT('&&rowid') data_object_id#,
DBMS_ROWID.ROWID_RELATIVE_FNO('&&rowid') rfile#,
DBMS_ROWID.ROWID_BLOCK_NUMBER('&&rowid') block#,
DBMS_ROWID.ROWID_ROW_NUMBER('&&rowid') row#
from dual;
因篇幅问题不能全部显示,请点此查看更多更全内容