Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Row migrated in new data blocks

Row migrated in new data blocks

From: Fabio Cannavaro <fatti_at_icazzi.tuoi>
Date: Thu, 17 Aug 2006 14:38:01 +0200
Message-ID: <44e46322$0$30239$4fafbaef@reader1.news.tin.it> 





If a row in data block, after some heavy update, is too long and it is 
migrated to a new data block (assuming it can contain it) I read that 
original piece row is preserved from Oracle to point to new row that 
also take the original rowid.



Now I think that in some cases database should be veru full of "row 
pointing" rows...and I imagine this is not so good...



Is it so frequent?



Is there a way to optimize this situation?



Regards.



F.
Received on Thu Aug 17 2006 - 07:38:01 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US