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

Question

Sumit Kesarwani · Answer

and 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.

interview

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

Sumit Kesarwani

Can you answer this question?

1 Answers

Liked By