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 ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
