Understanding Oracle High Water Mark (HWM) and Performance Optimization

Oracle Logical Storage Architecture Oracle's logical storage management consists of four hierarchical structures: tablespaces, segments, extents, and blocks. Database Blocks The block is Oracle's smallest storage unit, typically 8KB in size. All I/O operations occur at the block level. The block size is determined by the DB_BLOCK_SIZE paramete ...

Posted on Thu, 09 Jul 2026 16:14:01 +0000 by ericburnard