EXPLAIN THE DIFFERENCE BETWEEN A DATA BLOCK, AN EXTENT AND A SEGMENT?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
MYSQL 
 1458  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    Explain the difference between a data block, an extent and a segment?

     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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!