79 - [Oracle 19C] How table data is stored

 

 

 

 If an entire row can be inserted into a single data block, then Oracle stores the row as one row piece.

 if all of a row's data cannot be inserted into a single data block or if an update to an existing row causes the row to outgrow its data block, then Oracle stores the row using multiple row pieces

 A data block usually contains only one row piece for each row.

 When Oracle must store a row in more than one row piece, it is chained across multiple blocks.