您的当前位置:首页Oracle数据库中的数据块存储 -- data block storage in an Oracle Database

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;

因篇幅问题不能全部显示,请点此查看更多更全内容

Top