oracle 行链接和行迁移

1. oracle 行连接和行迁移，这两个是怎么个概念？
行迁移是因为Update，将行变长，原来的块已经放不下，行被挪进新块，这叫行迁移。
行链接，是行一开始就太大了，比如你插入了个10000字节的行，必须要分两个块存放。

2. 它们分别是在什么情况下产生的呢？
上面已经有描术

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