Oracle Database – planning the Block Size of Redo Log Files

  Planning the Block Size of Redo Log Files – unlike the database block size which can be between 2K and 32K redo log files always default to a block size that is equal to the physical sector size of the disk historically this has typically been 512 bytes (512B) some newer high-capacity disk drives offer 4K byte (4K) sector sizes for both increased ECC capability and improved format efficiency most Oracle Database platforms are able to detect this larger sector size the database then automatically creates redo log files with a 4K block size on those disks

Leave a Reply

You must be logged in to post a comment.