O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

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

Segment Management in Oracle Database 10g

As a precursor to our discussion on segment management, this chapter starts with some preliminary information about data-storage principles in Oracle. Oracle databases use data files to hold data in the database. This data is written to the data files in a proprietary format read only by the database server. Oracle also uses temp files (a form of data files) exclusively with temporary tablespaces.

Data files are made up of segments and extents. There are different types of segments, specific to the database objects they hold—for example, data segments for tables and index segments for indexes. An extent is a contiguous set of data blocks within a segment, whose size is determined by the DBA either during ...

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