BBED kdbr[0]寻址
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
5from 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 @110 8090
sb2 kdbr @112 8084
BBED> p *kdbr
rowdata
----------
ub1 rowdata @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, 48 bytes @44
.........................................................
***************************************************************************************
sys@OMREP> select 8090+68+(2-1)*24 from dual;
8090+68+(2-1)*24
----------------
8182
FOR ASSM
real offset = kdbr +76 + (itls-1) *24
FOR MSSM
real offset= kdbr + 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
表示看不懂:shock:
页:
[1]