O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3.1. Identifying Segments, Extents, and Data Blocks

Starting with the highest level of Oracle disk-space management are tablespaces. Drilling down, you find segments that can reside in only one tablespace. Each segment is constructed from one or more extents. Each of these extents can reside in only one datafile. Thus, for a segment to straddle multiple datafiles, it must be constructed from multiple extents, which are located in separate datafiles. An extent is composed of a contiguous set of data blocks, which is at the lowest level of space management. A data block is a fixed number of bytes of disk space.

Figure 3.1 shows the relationship among segments, extents, and data blocks.

The data block size is a tablespace attribute. The SYSTEM ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required