oracle段头+位图

SQL> select OBJ#,DATAOBJ#,TS#,block#,FILE#,BOBJ#,TAB#,COLS,CLUCOLS from tab$ where OBJ#=51146 or OBJ#=51148 or OBJ#=51150 or OBJ#=51151;                                       

      OBJ#   DATAOBJ#        TS#     BLOCK#      FILE#      BOBJ#       TAB#       COLS    CLUCOLS
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
     51146      51146          4         11          4                                3
     51148      51148          4         27          4                                8
     51150      51150          4         43          4                                4
     51151      51151          4         51          4                                3

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('240001e',  'xxxxxxxxxx')) file#,                                                                                       dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('240001e', 'xxxxxxxxxx')) block#  from dual;

     FILE#     BLOCK#
---------- ----------
         9         30

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('0100000a',  'xxxxxxxxxx')) file#,                                                                                       dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('240001e', 'xxxxxxxxxx')) block#  from dual;

     FILE#     BLOCK#
---------- ----------
         4         30

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('0100000a',  'xxxxxxxxxx')) file#,                                                                                       dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('0100000a', 'xxxxxxxxxx')) block#  from dual;

     FILE#     BLOCK#
---------- ----------
         4         10

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('01000009','xxxxxxxxxx')) file#,                                                                                    
  2  dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('01000009','xxxxxxxxxx')) block#  from dual;                                                                              

     FILE#     BLOCK#
---------- ----------
         4          9

SQL>

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('01000011','xxxxxxxxxx')) file#,dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('01000011','xxxxxxxxxx')) block#  from dual;

     FILE#     BLOCK#
---------- ----------
         4         17

 

 

 

CF055F0 00000000 00000000 00000000 BFDB2302  [.............#..]
  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 1      #blocks: 8    
                  last map  0x00000000  #maps: 0      offset: 2716 
      Highwater::  0x01000011  ext#: 0      blk#: 8      ext size: 8     ------file 4 block 17
  #blocks in seg. hdr's freelists: 0    
  #blocks below: 5    
  mapblk  0x00000000  offset: 0    
                   Unlocked
  --------------------------------------------------------
  Low HighWater Mark :
      Highwater::  0x01000011  ext#: 0      blk#: 8      ext size: 8    
  #blocks in seg. hdr's freelists: 0    
  #blocks below: 5    
  mapblk  0x00000000  offset: 0    
  Level 1 BMB for High HWM block: 0x01000009
  Level 1 BMB for Low HWM block: 0x01000009
  --------------------------------------------------------
  Segment Type: 1 nl2: 1      blksz: 8192   fbsz: 0     
  L2 Array start offset:  0x00001434
  First Level 3 BMB:  0x00000000
  L2 Hint for inserts:  0x0100000a
  Last Level 1 BMB:  0x01000009  --------file 4 block 9
  Last Level II BMB:  0x0100000a---------file 4 block 10
  Last Level III BMB:  0x00000000---------空
     Map Header:: next  0x00000000  #extents: 1    obj#: 51146  flag: 0x10000000
  Inc # 0
  Extent Map
  -----------------------------------------------------------------
   0x01000009  length: 8    
 
  Auxillary Map
  --------------------------------------------------------
   Extent 0     :  L1 dba:  0x01000009 Data dba:  0x0100000c
  --------------------------------------------------------
 
   Second Level Bitmap block DBAs
   --------------------------------------------------------
   DBA 1:   0x0100000a
 
End dump data blocks tsn: 4 file#: 4 minblk 11 maxblk 11

 

 

 

SQL> alter table scott.DEPT allocate extent (size 20m);                                                                                                                        

Table altered.

SQL> alter system checkpoint;                                                                                                                                                  

System altered.

SQL> alter system checkpoint;                                                                                                                                                  

System altered.

SQL> alter system dump datafile 4 block 11;                                                                                                                                    

System altered.

SQL> select SEGMENT_NAME,EXTENT_ID, FILE_ID,BLOCK_ID,BLOCKS from dba_extents where FILE_ID=4 and SEGMENT_NAME='DEPT';                                                          

SEGMENT_NAME               EXTENT_ID    FILE_ID   BLOCK_ID     BLOCKS
------------------------- ---------- ---------- ---------- ----------
DEPT                               0          4          9          8
DEPT                               1          4        137        128
DEPT                               2          4        265        128
DEPT                               3          4        393        128
DEPT                               4          4        521        128
DEPT                               5          4        649        128
DEPT                               6          4        777        128
DEPT                               7          4        905        128
DEPT                               8          4       1033        128
DEPT                               9          4       1161        128
DEPT                              10          4       1289        128
DEPT                              11          4       1417        128
DEPT                              12          4       1545        128
DEPT                              13          4       1673        128
DEPT                              14          4       1801        128
DEPT                              15          4       1929        128
DEPT                              16          4       2057        128
DEPT                              17          4       2185        128
DEPT                              18          4       2313        128
DEPT                              19          4       2441        128
DEPT                              20          4       2569        128

21 rows selected.

SQL>

 Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 21     #blocks: 2568 
                  last map  0x00000000  #maps: 0      offset: 2716 
      Highwater::  0x01000011  ext#: 0      blk#: 8      ext size: 8    
  #blocks in seg. hdr's freelists: 0    
  #blocks below: 5    
  mapblk  0x00000000  offset: 0    
      Disk Lock:: Locked by xid:  0x0001.00a.00000324
  --------------------------------------------------------
  Low HighWater Mark :
      Highwater::  0x01000011  ext#: 0      blk#: 8      ext size: 8    
  #blocks in seg. hdr's freelists: 0    
  #blocks below: 5    
  mapblk  0x00000000  offset: 0    
  Level 1 BMB for High HWM block: 0x01000009
  Level 1 BMB for Low HWM block: 0x01000009
  --------------------------------------------------------
  Segment Type: 1 nl2: 1      blksz: 8192   fbsz: 0     
  L2 Array start offset:  0x00001434
  First Level 3 BMB:  0x00000000
  L2 Hint for inserts:  0x0100000a
  Last Level 1 BMB:  0x01000a0a
  Last Level II BMB:  0x0100000a
  Last Level III BMB:  0x00000000
     Map Header:: next  0x00000000  #extents: 21   obj#: 51146  flag: 0x10000000
  Inc # 0
  Extent Map
  -----------------------------------------------------------------
   0x01000009  length: 8    
   0x01000089  length: 128  
   0x01000109  length: 128  
   0x01000189  length: 128  
   0x01000209  length: 128  
   0x01000289  length: 128  
   0x01000309  length: 128  
   0x01000389  length: 128  
   0x01000409  length: 128  
   0x01000489  length: 128  
   0x01000509  length: 128  
   0x01000589  length: 128  
   0x01000609  length: 128  
   0x01000689  length: 128  
   0x01000709  length: 128  
   0x01000789  length: 128  
   0x01000809  length: 128  
   0x01000889  length: 128  
   0x01000909  length: 128  
   0x01000989  length: 128  
   0x01000a09  length: 128  
 
  Auxillary Map
  --------------------------------------------------------
   Extent 0     :  L1 dba:  0x01000009 Data dba:  0x0100000c
   Extent 1     :  L1 dba:  0x01000089 Data dba:  0x0100008b
   Extent 2     :  L1 dba:  0x01000109 Data dba:  0x0100010b
   Extent 3     :  L1 dba:  0x01000189 Data dba:  0x0100018b
   Extent 4     :  L1 dba:  0x01000209 Data dba:  0x0100020b
   Extent 5     :  L1 dba:  0x01000289 Data dba:  0x0100028b
   Extent 6     :  L1 dba:  0x01000309 Data dba:  0x0100030b
   Extent 7     :  L1 dba:  0x01000389 Data dba:  0x0100038b
   Extent 8     :  L1 dba:  0x01000409 Data dba:  0x0100040b
   Extent 9     :  L1 dba:  0x01000489 Data dba:  0x0100048b
   Extent 10    :  L1 dba:  0x01000509 Data dba:  0x0100050b
   Extent 11    :  L1 dba:  0x01000589 Data dba:  0x0100058b
   Extent 12    :  L1 dba:  0x01000609 Data dba:  0x0100060b
   Extent 13    :  L1 dba:  0x01000689 Data dba:  0x0100068b
   Extent 14    :  L1 dba:  0x01000709 Data dba:  0x0100070b
   Extent 15    :  L1 dba:  0x01000789 Data dba:  0x0100078b
   Extent 16    :  L1 dba:  0x01000809 Data dba:  0x0100080b
   Extent 17    :  L1 dba:  0x01000889 Data dba:  0x0100088b
   Extent 18    :  L1 dba:  0x01000909 Data dba:  0x0100090b
   Extent 19    :  L1 dba:  0x01000989 Data dba:  0x0100098b
   Extent 20    :  L1 dba:  0x01000a09 Data dba:  0x01000a0b
  --------------------------------------------------------
 
   Second Level Bitmap block DBAs
   --------------------------------------------------------
   DBA 1:   0x0100000a
 
End dump data blocks tsn: 4 file#: 4 minblk 11 maxblk 11

 

SQL> select to_char(8,'xxxxxxxxxxxx') from dual;                                                                                                                               

TO_CHAR(8,'XXXXXXXXXXXX')
--------------------------
            8

SQL> select to_char(128,'xxxxxxxxxxxx') from dual;                                                                                                                             

TO_CHAR(128,'XXXXXXXXXXXX'
--------------------------
           80