Logical Database Components
We have seen that the physical components of the database comprise various files. Logically, however, the database consists of data blocks, extents, segments, and tablespaces.
Data Blocks
GEEK SPEAK: An Oracle database block is a set of contiguous operating-system blocks. A data block is the smallest unit of data storage and can't span data files.
Note
Each block in the database buffer is the size of a data block.
If you want to change the database block size of a database after it is created, you will have to re-create the database; otherwise, the database might become corrupt.
When choosing the size of a data block you should consider the type of database environment. For example, is it a DSS or OLTP environment? ...
Get e-Commerce Applications Using Oracle8i and Java from Scratch 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.
