What is Row Chaining ?

In Circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs , the data for the row is stored in a chain of data block (one or more) reserved for that segment.

  • Interview Candidate
  • 1
  • 2621

Showing Answers 1 - 1 of 1 Answers

feroz

  • Aug 29th, 2006
 

If a row is too large to fit into a single database block row chaining happens. For example, if you use a 4KB blocksize for your database, and you need to insert a row of 8KB into it, Oracle will use 3 blocks and store the row in pieces.

Some conditions that will cause row chaining are:

Tables whose rowsize exceeds the blocksize.

Tables with long and long raw columns are prone to having chained rows.

Tables with more then 255 columns will have chained rows as Oracle break wide tables up into pieces.

So, instead of just having a forwarding address on one block and the data on another we have data on two or more blocks.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions