Oracle "formats" the
database files into a number of Oracle blocks when they are first
created—making it easier for the RDBMS software to manage the files and easier
to read data into the memory areas.
The block size should be a
multiple of the operating system block size. Regardless of the block size, the
entire block is not available for holding data; Oracle takes up some space to
manage the contents of the block. This block header has a minimum size, but it
can grow.
These Oracle
blocks are the smallest unit of storage. Increasing the Oracle block size can
improve performance, but it should be done only when the database is first
created.
Each Oracle block is numbered sequentially for each
database file starting at 1. Two blocks can have the same block address if they
are in different database files.
No comments:
Post a Comment