top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+4 votes
174 views
Explain the difference between a data block, an extent and a segment?
posted Jan 23, 2015 by Shivaranjini

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

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 Feb 20, 2015 by Manikandan J
...