MSSM下段管理
sys@OMREP> select file_id,block_id from dba_extents where segment_name='T' and owner='SYS';FILE_ID BLOCK_ID
---------- ----------
1 33128
sys@OMREP> select header_file,header_block from dba_segments where segment_name='T' and owner='SYS';
HEADER_FILE HEADER_BLOCK
----------- ------------
1 33128
BBED> set dba 1,33128
DBA 0x00408168 (4227432 1,33128)
BBED> map
File: /u01/app/oracle/oradata/omrep/system01.dbf (1)
Block: 33128 Dba:0x00408168
------------------------------------------------------------
Unlimited Data Segment Header
struct kcbh, 20 bytes @0
struct ktech, 72 bytes @20
struct ktemh, 16 bytes @92
struct ktetb, 8 bytes @108
struct ktshc, 8 bytes @4148
struct ktsfs_seg, 20 bytes @4156
struct ktsfs_txn, 320 bytes @4176
ub4 tailchk @8188
**********************************************************************************
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> map
File: /u01/app/oracle/oradata/omrep/system01.dbf (1)
Block: 33129 Dba:0x00408169
------------------------------------------------------------
KTB Data Block (Table/Cluster)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdbh, 14 bytes @92
struct kdbt, 4 bytes @106
sb2 kdbr @110
ub1 freespace @114
ub1 rowdata @8176
ub4 tailchk @8188
*********************************************************************
sys@OMREP> @trace
trace_file_name
-----------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/omrep/omrep/trace/omrep_ora_3098.trc
buffer tsn: 0 rdba: 0x00408168 (1/33128)
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 1 #blocks: 7
last map0x00000000#maps: 0 offset: 4128
Highwater::0x0040816aext#: 0 blk#: 1 ext size: 7
#blocks in seg. hdr's freelists: 1
#blocks below: 1
mapblk0x00000000offset: 0
Unlocked
Map Header:: next0x00000000#extents: 1 obj#: 13980flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x00408169length: 7
BH (0x2dbf6304) file#: 1 rdba: 0x00408169 (1/33129) class: 1 ba: 0x2db0e000
Itl Xid Uba FlagLck Scn/Fsc
0x01 0x0006.001.000002670x00c00212.004e.3a--U- 2fsc 0x0000.0013670e
0x02 0x0000.000.000000000x00000000.0000.00---- 0fsc 0x0000.00000000
LSSM下段头没有数据，存放段头信息
完全不懂啊
页:
[1]