Segment is the entity that uses the physical storage space within the database. Some of the common segment types are:
- Table: Stores data in columns and rows.
- Index: Improves the access to the table data. Helps in increasing the performance of data extraction.
- Rollback: Rolls back the uncommitted data.
- Partition: Divides a table into smaller pieces for performance.
As shown in the figure, group of extents make a segment. Each extent is made of a collection of oracle database blocks , Minimum size of extent is five blocks. The database block sizes are in multiples of 2 like 2k,4k,8k and 16k.

No comments yet
Comments feed for this article