Oracle Data Block Overview

• Oracle manages the storage space in the datafiles of a database in units called data blocks.  
• Data block is the smallest unit of data used by a database.  
• At the physical, operating system level, all data is stored in bytes. Each operating system has a block size. Oracle requests data in multiples of Oracle data blocks, not operating system blocks.  
• The standard block size is specified by the initialization parameter DB_BLOCK_SIZE. 
• You can specify of up to five nonstandard block sizes. 
• The data block sizes should be a multiple of the operating system's block size within the maximum limit to avoid unnecessary I/O. 
• Oracle data blocks are the smallest units of storage that Oracle can use or allocate.

Related Topic: Data Block Format

People who read this post also read :

Posted in: Data Block,Logical Storage,Physical Storage