Difference between a data block, an extent and a segment.

please any one explain me the difference between a data block, an extent and a segment.
 thanks in advance :)

Views: 55

▶ Reply to This

Replies to This Discussion

Permalink Reply by Xiao Sheard on October 9, 2013 at 6:56pm

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.

Permalink Reply by Bonita Croslin on October 9, 2013 at 6:58pm

thank you for sharing your answer. its also helped me. !

Permalink Reply by Buddy Macdonnell on October 11, 2013 at 6:36pm

oh realy thanks Ernie for your question... and  Xiao thank you for your ans on that topic :) 

Permalink Reply by Celine Kulinski on November 18, 2013 at 12:48pm

Xiao Thankx for your answer.

▶ Reply to Discussion

RSS

Oracle Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service