Storage in a Oracle datafile: A table or an index is called a segment on the storage side of the Oracle database. Such een segment consists of extents. And these extents consists of blocks (the smallest unit of storage in a Oracle database). Most databases I see have a db_block_size of 8K (8192 bytes). If […]