Home > DeveloperSection > Interviews > Explain the difference between a data block, an extent and a segment?

Posted on    January-31-2014 11:58 PM

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  1223  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    January-31-2014 1:00 AM

 A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.


Don't want to miss updates? Please click the below button!

Follow MindStick