BBED kdbr[0]寻址

湖北佛 · 发表于 2013-9-8 22:36:22

马上注册，结交更多好友，享用更多功能^_^

您需要登录才可以下载或查看，没有账号？立即注册

x

sys@OMREP> select rowid,

  2       dbms_rowid.rowid_relative_fno(rowid) rel_fno,
  3       dbms_rowid.rowid_block_number(rowid) bno,
  4       dbms_rowid.rowid_row_number(rowid) rowno
  5  from t where a=2;

ROWID                REL_FNO       BNO    ROWNO
------------------ ---------- ---------- ----------
AAADacAABAAAIFpAAB       1    33129       1

BBED> set dba 1,33129
      DBA          0x00408169 (4227433 1,33129)

*************************************************************************************

BBED> p kdbr
sb2 kdbr[0]                               @110    8090
sb2 kdbr[1]                               @112    8084

BBED> p *kdbr[0]
rowdata[6]
----------
ub1 rowdata[6]                            @8182    0x2c

BBED> map /v
File: /u01/app/oracle/oradata/omrep/system01.dbf (1)
Block: 33129                               Dba:0x00408169
------------------------------------------------------------
KTB Data Block (Table/Cluster)
.........................................................
struct ktbbhitl[2], 48 bytes          @44
.........................................................

***************************************************************************************
sys@OMREP> select 8090+68+(2-1)*24 from dual;

8090+68+(2-1)*24
----------------
         8182

FOR ASSM
real offset = kdbr[n] +  76 + (itls-1) *24

FOR MSSM
real offset= kdbr[n] + 68  + (itls-1) *24

sys@OMREP> select tablespace_name,extent_management,segment_space_management from dba_tablespaces;

TABLESPACE_NAME             EXTENT_MAN SEGMEN
------------------------------ ---------- ------
SYSTEM                      LOCAL    MANUAL
SYSAUX                      LOCAL    AUTO
UNDOTBS1                      LOCAL    MANUAL
TEMP                         LOCAL    MANUAL
USERS                         LOCAL    AUTO

asd2881323 · 发表于 2014-1-21 08:47:26

表示看不懂:shock:

账号		自动登录	找回密码
密码			立即注册

[Oracle] BBED kdbr[0]寻址

马上注册，结交更多好友，享用更多功能^_^