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